Installing and configuring the DB2 Run Time Client

When not integrating with Network Manager, and installing the Netcool Configuration Manager Tivoli Common Reporting component with a DB2 database, 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

You also perform these actions when integrating Netcool Configuration Manager using a DB2 database with a version of Network Manager that does not use a DB2 database.

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

Restriction: This procedure applies only to the following two scenarios:
  • Installations of Netcool Configuration Manager that are not integrated with Network Manager, exercise the option to install Tivoli Common Reporting, and utilize a DB2 database.
  • Installations of Netcool Configuration Manager that use a DB2 database and are integrated with Network Manager using a different database.
For all other scenarios, ignore this procedure and move on to the topic describing how to add regular expression support to the DB2 database.

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 supplied when installing the Tivoli Common Reporting components.

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 Tivoli Common Reporting component.
      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 hostname> server <db port>
    Tip: The node name is at our discretion.
  4. Catalog the DB2 database instance using a command similar to the following: 
    db2 catalog database <database name> at node <node name>

    For example:

    db2 catalog database itncm at node dbnode
db2 terminate
  5. Test your connection using a command similar to the follownig:
    db2 connect to <database name> user <db username>

    For example:

    db2 connect to itncm user root