DB2 clients

Because Trade 6.1 uses the DB2 universal JDBC Type 4 driver, you do not need to configure the DB2 clients on the appserver systems any more (as was needed for previous versions of Trade). If you encounter issues when accessing the database, follow these steps to resolve the connection problems.

  1. Log on to the appserver machine (pt) as the DB2 instance owner and start a db2 shell.

  2. Using this shell, catalog the remote database server db (thus creating a local node representing it) by using the following command:

    db2 catalog tcpip node <your_local_node> remote <db2_server_hostname> server <port_from_the_services_file_on_your_OS_(50000)>

    In our case, the correct command was:

    db2 catalog tcpip node pt remote brazos server 50000

  3. Catalog the remote database ptradedb:

    db2 catalog database ptradedb as ptradedb at node <your_local_node>

    In our case, the correct command was:

    db2 catalog database ptradedb as ptradedb at node pt

  4. Verify the database connectivity from the DB2 client machine (pt):

    db2 connect to tradedb user <db_user> using <password>

    In our case, the following command displayed the information shown in Example 10-7:

    db2 connect to ptradedb user db2rcli using <password>

    Example 10-7 Database connectivity from DB2 clients to DB2 server 

    Database Connection Information 
Database server        = DB2/AIX64 9.1.0 
SQL authorization ID   = DB2RCL1 
Local database alias   = PTRADEDB

Next