Configuring the report development tools: Tasks for DB2

Linux To let the developer system access the IBM® Rational® Insight data warehouse for running the reports, catalog the data warehouse and run the reports.
About this task
To configure the Rational Insight database catalog and the Rational Insight models:
  1. Catalog the data warehouse.
    • If the database is not installed locally, to enable Cognos® Data Manager to store the catalogs in a database, create a database with an alias named RICTG.
    • 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