• 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

1. Stop the IBM Cognos 8 services, on all servers in 1 environment.

2. 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.

3. 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

4. Start the IBM Cognos 8 service again.