Cognos 8 Database Cleanup Scripts

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