Configuring the report development tools: Tasks for Oracle Server

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 ORACLE "USERNAME/PASSWORD@RICTG" -c
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.
    2. Restore the catalog by running the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catrestore ORACLE "USERNAME/PASSWORD@RICTG" [INSTALLDIR]/datamgr/insight_catalog/OOTBDMCatalog.ctg
      where USERNAME and PASSWORD are the user name and password of a valid Oracle 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 ORACLE "USERNAME/PASSWORD@RICTG" J 
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.
    2. To run the fact jobs, run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./rundsjob ORACLE "USERNAME/PASSWORD@RICTG" OOTBE2E
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.

Feedback