Setting up the Db2 client on InfoSphere Master Data Management Collaboration Server - Collaborative Edition

You must set up the DB2® client on InfoSphere® Master Data Management Collaboration Server - Collaborative Edition.

Before you begin

Before you set up the Db2 client on the operating system running InfoSphere Master Data Management Collaboration Server - Collaborative Edition, you must:
  • Ensure that the system or database administrator has installed Db2 Admin/Developer/Run-Time Client on the operating system.
  • Get the Db2 client home directory on the operating system.
  • Get the host name, port number, and database name for the Db2 database server from the database administrator.

Procedure

  1. Add the following line to the .bash_profile file in the home directory of the user ID that is used for installing InfoSphere Master Data Management Collaboration Server - Collaborative Edition.
    . <Db2 client home>/sqllib/db2profile
    Where you replace <Db2 client home> with the Db2 client home directory.
    For example: . /opt/db2inst1/sqllib/db2profile
  2. Log out and back in again in to the operating system. Ensure that the Db2 libraries are added by checking for the . <Db2 client home>/sqllib/bin directory in the $PATH variable.
  3. Set up Db2 server information in the Db2 client using the following commands:
    db2 "catalog tcpip node <nodename> remote <dbhostname>
    server <sname/port#>"
    db2 terminate
    db2 "catalog database <dbname> as <dbname> at node <nodename>"
    db2 terminate
    Where you replace the following variables:
    <nodename>
    The name for the remote instance.
    <dbhostname>
    The host name or IP address of the database server.
    <sname/port#>
    The service name or port number for the connection port of the Db2 instance.
    <dbname>
    The database name.