DB2 Database Configuration

Step 1 Step 2 Step 3 Step 4 Step 5
AIX Substep 1
AIX Substep 2


Step 2: DB2 on AIX Database Connection Instructions

Substep 2: AIX Client Setup Instructions

On the client, you must setup DB2 to use the remote database.
  1. As root user on the client, put the same line in "/etc/services" file that you put in the server's "/etc/services" file:
    db2srvc <port_number>/tcp #DB2 connection service port
    where:
    • <port_number> should be the same one you used for Step2 - AIX Substep1.
  2. Use the DB2 command line to login as DB2 administrator and type:
    1. CATALOG TCPIP NODE SAMPNODE REMOTE <hostname> SERVER db2srvc
      where
      • <hostname> is the hostname of the "server" machine
  3. On the DB2 command line type:
    1. CATALOG DATABASE DB2SAMP AS SAMPLE AT NODE SAMPNODE

Take Note!
  • Be sure to enter db2srvc in all lowercase letters.
  • The "server" refers to the machine on which the actual DB2 database resides. The "client" refers to the machine that uses the DB2 database which resides on the "server". The "server" and "client" can be the same machine.