You can run SQL scripts to delete all the tables in any of the following databases that IBM Cognos 8 components use:
content store for data that IBM Cognos 8 needs to operate
delivery database for report notifications
log database for log messages
metric store for metric package content and Metric Studio user preferences
When you delete a table, its structural definition and data are deleted permanently from the database. For the metric store, database objects may also be deleted.
When you restart the IBM Cognos 8 service, a new set of required database tables are created automatically in the location specified by your configuration settings.
Steps
Stop the IBM Cognos 8 services, on all servers in 1 environment.
-
Go to the appropriate directory:
To delete tables from the log database, go to c8_location\configuration\schemas\logging.
To delete tables from the content store, go to c8_location\configuration\schemas\content.
To delete tables from the notification database, go to c8_location\configuration\schemas\delivery.
To delete tables from the metric store, go to c8_location\configuration\schemas\cmm.
-
Depending on the database and database type, run one of the scripts listed in the table below, in the appropriate database tool to delete the tables.
Database
Database Type
Script Name
Content store
DB2
dbClean_db2.sql
Derby
dbClean_derby.sql
Microsoft SQL Server
dbClean_mssqlserver.sql
Oracle
dbClean_oracle.sql
Sybase
dbClean_sybase.sql
Notification
DB2
NC_DROP_DB2.sql
Derby
NC_DROP_Derby.sql
Microsoft SQL Server
NC_DROP_MS.sql
Oracle
NC_DROP_ORA.sql
Sybase
NC_DROP_SYBASE.sql
Log
DB2
LS_dbClean_db2.sql
Derby
LS_dbClean_derby.sql
Microsoft SQL Server
LS_dbClean_mssql.sql
Oracle
LS_dbClean_oracle.sql
Sybase
LS_dbClean_sybase.sql
Metric store
DB2
cmm_uninstall dbalias username password
Specify the dbalias only if a database with the same name is already cataloged.
Microsoft SQL
cmm_uninstall metric_store_name database_name Admin_user_name password
Oracle
cmm_uninstalldatabase_name database_user_name password
Replace database_name with the name in the tnsnames.ora file that refers to the database SID for Metric Studio
Start the IBM Cognos 8 service again.