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  

Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121 © 2008-2017.
If you may any questions please contact us: