Configuring the report development tools: Tasks for DB2

Linux To let the developer system access the Rational® Common Reporting data warehouse for running the reports, catalog the data warehouse and run the reports.
About this task
To configure the Rational Common Reporting database catalog and the Rational Common Reporting models:
  1. Catalog the data warehouse.
    • If the database is installed locally, create a database.
    1. Run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catmanage DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" -c
      where USERNAME and PASSWORD are the user name and password of a valid DB2® user account.
    2. Restore the catalog by running the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catrestore DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" [INSTALLDIR]/datamgr/insight_catalog/OOTBDMCatalog.ctg
      where USERNAME and PASSWORD are the user name and password of a valid DB2 user account.
  2. Run the ETL jobs.
    1. To list all fact jobs in catalog, run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catlist DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" J
      where USERNAME and PASSWORD are the user name and password of a valid DB2 user account.
    2. To run the fact job, run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./rundsjob DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" OOTBE2E
      where USERNAME and PASSWORD are the user name and password of a valid DB2 user account.

Feedback