Configuring an ODBC connection

Before you install Performance Management reports, you must configure an ODBC connection between the Tivoli® Common Reporting server and the Performance Management DB2® machine. The purpose of this configuration is to enable Tivoli Common Reporting to retrieve the required data from the Performance Management DB2 database by using a local DB2 client.

1. On the Tivoli Common Reporting server, connect to the Performance Management DB2 database by using the DB2 client and catalog a node. Run the following command:

   su - dbuser
   db2 catalog tcpip node <pm_db2_node_name> remote <pm_db2_ip_address> server <pm_db2_instance_port>

   for example

   su - smadmin
   db2 catalog tcpip node DB2_SRVR remote 123.456.789.123 server 50000

2. On the Tivoli Common Reporting server, connect to the Performance Management DB2 database by using the DB2 client and catalog the DB2 warehouse.

   If you want to create a connection to generate reports for the Response Time Monitoring Agent or the WebSphere® Applications agent, run the following command:

   su - dbuser
   db2 catalog db WAREHOUS at node <pm_db2_node_name>

   for example

   su - smadmin
   db2 catalog db WAREHOUS at node DB2_SRVR

   If you want to create a connection to generate reports for the Synthetic Playback agent, you must catalog the DB2 DATAMART. Run the following command:

   su - dbuser
   db2 catalog db DATAMART as DATAMART at node <pm_db2_node_name>

   for example

   su - smadmin
   db2 catalog db DATAMART as DATAMART at node DB2_SRVR