How to install the IBM Cloud Application Performance Management reports in an IBM Cognos Analytics 11.x environment

1) If your IBM Cloud APM Db2 server is not installed on the same host as your IBM Cognos Analytics 11.x server then the APM databases need to be cataloged on the IBM Cognos Analytics 11.x server host by performing these steps: 

    1a) Install the IBM Db2 client on the same host where IBM Cognos Analytics 11.x is installed.
    1b) As the Db2 instance user on your IBM Cognos server, enter the following commands: 

              db2 catalog tcpip node APMNODE remote your-db2-server-hostname server your-db2-instance-port

                             where

                                  -  you replace your-db2-server-hostname with the hostname of the IBM Cloud APM Db2 server and

                                 -  you replace your-db2-instance-port with the port number for your Db2 instance.   If your IBM Cloud APM server is configured for a local Db2 server then the Db2 instance port number is 50000 by default.

                  db2 catalog db WAREHOUS as WAREHOUS at node APMNODE
                  db2 catalog db DATAMART as DATAMART at node APMNODE
                  

       Note: see the Additional Information section of this document for links to the Db2 11.1 topics with the full syntax for the db2 catalog tcpip node and db2 catalog database commands. 

2) Ensure the IBM Cognos Analytics install_location/drivers directory contains the Db2 driver jar file (db2jcc4.jar).     The jar file is available from the java directory of your IBM Db2 server.  

3) Create 2 Cognos data sources for the IBM Cloud APM databases using the data source creation instructions at this link:     https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_asg_createdatasou rce.html

Note:   do not use the IBM Cognos Analytics Manage -> Data server connections user interface to create the data sources. 

3a) The first data source connection must be named TDW

- When creating the data source, select IBM Db2 for the type  and select the check box to Configure JDBC  

- On the  "Specify the database connection string" page, enter WAREHOUS as the database name and create a signon for itmuser and its password. Test the connection before proceeding to the next page of the wizard. 

- On the "Specify the IBM Db2 JDBC (Connection String)" page, specify the hostname where your IBM Cloud APM Db2 server is installed, specify the port number for your IBM Cloud APM Db2 instance, and WAREHOUS for the database name.  If your IBM Cloud APM server is configured for a local Db2 server then the Db2 instance port number is 50000 by default.  Test the connection before proceeding to the next page of the wizard.

3b) The second data source connection must be named APPMART

- When creating the data source, select IBM Db2 for the type  and select the check box to Configure JDBC  

- On the  "Specify the database connection string" page, enter DATAMART as the database name and create a signon for itmuser and its password.

- On the "Specify the IBM Db2 JDBC (Connection String)" page, specify the hostname where your IBM Cloud APM Db2 server is installed, specify the port number for your IBM Cloud APM Db2 instance, and DATAMART for the database name. If your IBM Cloud APM server is configured for a local Db2 server then the Db2 instance port number is 50000 by default.

4)  Download the IBM Cloud APM reports package from Passport Advantage.   The part number is listed in the IBM Cloud APM Knowledge Center topic at this location: https://www.ibm.com/support/knowledgecenter/SSHLNR_8.1.4/com.ibm.pm.doc/install/install_download_pm_part_no.html

5) Copy the IBM Cloud APM reports package zip file to your IBM Cognos Analytics server. Then extract the report_packages\KSN_reports.zip file, report_packages\KT5_reports.zip file, and report_packages\KYN_reports.zip file from the IBM Cloud APM reports package zip file.  Copy the 3 .zip files to the install_location/deployment directory of your Cognos Analytics server.

6) Open the IBM Cognos Analytics user interface and navigate to the Administration Console by selecting Manage -> Administration console 

7) Select the Configuration tab and from the side menu, select Content Administration

8) Click the New Import icon to display the New Import Wizard and choose a report package to import: 

8a) Select KSN_reports if you want to install the IBM Cloud APM Synthetic Playback agent reports and click Next.  Accept the defaults as you navigate through the wizard.  On the Public folders, directory, and library content page, select the check box for APM Synthetic.

8b) Select KT5_reports if you want to install the IBM Cloud APM  Response Time Monitoring agent reports and click Next.  Accept the defaults as you navigate through the wizard.  On the Public folders, directory, and library content page, select  the check box for Application Performance. 

8c) Select KYN_reports if you want to IBM Cloud APM  WebSphere Application agent reports and click Next.  Accept the defaults as you navigate through the wizard.  On the Public folders, directory, and library content page, select the check box for IBM Monitoring 8.1.2 WebSphere Reports. 

9) When you save the imported package, choose the  Save and run once option. Then select the option to run the reports now and click Run. 

10) Repeat steps 8 and 9 for each IBM Cloud APM agent report package that you want to install. 

11) After the IBM Cloud APM agent report packages are imported, the reports appear in the Team content  folder of the IBM Cognos Analytics user interface.  You can choose reports to run from that folder.  

Note:  you cannot launch the reports from the IBM Cloud APM console like you can when Tivoli Common Reporting is used for the reporting server.