ITCAM Agents for WebSphere Messaging Report version 7.1 installation fails on existing TCR 3.1

Ensure that TCR 3.1 is installed, configured and running, as described in the following documentation: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.psc.doc_1.1.0/install/tcr_t_install.html

After that, complete the following steps to get the product reports work with TCR 3.1:

1. Import report packages into the TCR 3.1 environment

To import the report packages, follow the steps listed here: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.psc.doc_1.1.0/tcr_original/ttcr_import.html

The report packages that are required in these steps are located on your host in the directory:
$ITCAM_WebSphere_Messaging_Image$/REPORTS/ITCAM_Agents_for_WebSphere_Messaging_v71/reports/cognos_reports/Messaging/packages
Where: $ITCAM_WebSphere_Messaging_Image$ is the directory to which you extracted the installation image of ITCAM agents for WebSphere Messaging.

Use the WebSphereMQReports.zip file for ITCAM agent for WebSphere MQ, and use the WebSphereBrokerReports.zip file for ITCAM agent for WebSphere Message Broker.

2. Configure database connections in the TCR 3.1 environment

To configure database connections, follow the steps listed here:
http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.psc.doc_1.1.0/tcr_original/ttcr_config_db.html.
Use TDW as the database name to configure the data source in Cognos.

3. Create shared dimension tables and populate the time dimension

To prepare Tivoli Data Warehouse for Tivoli Common Reporting, you must create the IBM_TRAM dimensions. These dimensions are required for running Cognos reports and using data models. This procedure creates the following dimension tables:

• Schema IBM_TRAM. TRAM stands for Tivoli Reporting and Analytics Model, the common data model used by Tivoli products.
• Table TIME_DIMENSION with years of time dimensional data and granularity to a specified number of minutes. Each row of this table is a unique minute key with various dimensions related to it, such as hour, weekday, day of month, and quarter.
• Table MONTH_LOOKUP, which globalizes the month names for Time Dimension.
• Table WEEKDAY_LOOKUP, which globalizes the weekday names for Time Dimension.
• ComputerSystem, another dimension conforming to the Tivoli Common Data Model.

For the procedure, you must use the database scripts. They are included in the extracted reports package within the following directory:
$ITCAM_WebSphere_Messaging_Image$/REPORTS/ITCAM_Agents_for_WebSphere_Messaging_v71/reports/cognos_reports/Messaging/db_scripts

Procedure for IBM DB2:

a) Copy the database scripts (*_DB2.sql files) from the $ITCAM_WebSphere_Messaging_Image$/REPORTS/ITCAM_Agents_for_WebSphere_Messaging_v71/reports/cognos_reports/Messaging/db_scripts directory to a location where they can be run against the Tivoli Data Warehouse.
b) Log on as the DB2 administrator. Your user ID must have administrator access to create the IBM_TRAM schema.
c) Connect to the Tivoli Data Warehouse database:db2 connect to WAREHOUS;
d) Execute the following sql files orderly.

• db2 -td# -vf drop_all_DB2.sql
• db2 -td# -vf create_table_DB2.sql
• db2 -td# -vf create_proc_DB2.sql (Add # at the end of sql file before execution)
• db2 -td# -vf call_proc_DB2.sql (Add # at the end of sql file before execution)
• db2 -td# -vf drop_index_DB2.sql
• db2 -td# -vf create_index_DB2.sql

The shared dimension tables are created and the time dimension are populated.