
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:
- 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.
- 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.
- 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.
- Run the ETL jobs.
- 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.
- 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.