Configuring DB2 Clients in a Two-Tier Environment

Before you start configuring your workstation, identify the TCP/IP name or the IP address from the OS/390 host, its port, and the DB2 subsystem you want to connect to.

After the DB2 client successfully installed, you should configure it to access the remote DB2 server, using the Configuration Assistant or the command line processor:

  • Log on to the system with a valid DB2 user ID.

  • Start the Configuration Assistant using the db2ca command.

  • Search for servers.

  • Test the connection using Configuration Assistant.


  • Catalog the TCP/IP node on the DB2 client:

    db2 catalog tcpip node node_name remote hostname
      server service_name
    db2 catalog tcpip node nhost390 remote
      server 1300
  • Catalog the database on the DB2 client:

    db2 catalog database database_name as database_alias
      at node node_name authentication auth_value
    db2 catalog database db2t as db2t
      at node nhost130 authentication dcs
  • Catalog the DCS database:

    db2 catalog DCS database dcs_name as dcs_aliast
    db2 catalog DCS database db2t as db2t
  • Test the client-server connection:

    db2 connect to db2t user os390id
    db2 "select * from sysibm.sysdummy1"
    db2 terminate