[zLinux] Cataloging the DB2 database

When installing Netcool Configuration Manager on Linux on System z, and using Cognos Analytics to view ITNCM reports, you must obtain and install the DB2 runtime client, catalogue the TCP/IP node (that is, the platform running the DB2 database), and also catalogue the DB2 database instance.

Before you begin

Restriction: This topic only applies to Netcool Configuration Manager installations on Linux on System z.
Installation of the DB2 database is a prerequisite, which is described in the DB2 Knowledge Center. You can access the DB2 Knowledge Center at the following link: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.doc/welcome.html

About this task

For information on configuring the DB2 Run Time Client, see the 'Configuring client-to-server connections using the command line processor' topic at the following link: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.qb.client.doc/doc/t0007243.html

You can install the DB2 runtime client after installing Netcool Configuration Manager. If you do, ensure you then catalog the Netcool Configuration Manager database using the same alias that you used during the Netcool Configuration Manager installation.

Procedure

  1. Download the DB2 Run Time Client.

    The runtime client can be obtained at the IBM Support Portal.

    1. On the IBM Support Portal, navigate to the Downloads tab and search for the version of the DB2 Run Time Client that you want to download.
    2. Select the appropriate link to display a table that lists the DB2 download packages.
    3. To download the DB2 Run Time Client, select the appropriate package from the table.

    For more information on the supported versions of DB2, see Software requirements.

  2. Install the DB2 Run Time Client as root user.
    1. Unzip and untar the file.
      The rtcl directory is created.
    2. From the rtcl directory, run the db2_install command.

      You can install the client locally or anywhere else, such as the icosuser home directory.
      Remember: You need to specify this directory when installing the Netcool Configuration Manager.
      As part of the installation, the sqllib subdirectory is created in the install directory of the runtime client.
  3. Catalog the TCP/IP Node (the platform running the DB2 database) using the following command:
    db2 catalog tcpip node <node name> remote <db server's fully qualified domain name> server <db port>
    Tip: The node name is discretionary.
  4. Catalog the DB2 database instance using the following command: 
    db2 catalog database <database name> at node <node name>
db2 catalog database itncm at node dbnode
db2 terminate
  5. Test your connection using the following command:
    db2 connect to <database name> user <db username>