Installing and Configuring DB2 Client to DB2 Server Communications


There are three types of DB2 clients : run time client, administration client, and application development client. To install and configure DB2 client to DB2 server connections, you must do the following:

  • The client machine must meet the necessary installation requirements (operating system, CPU, memory, and disk space for DB2 product installation).

  • The client machine has the necessary user accounts for installation and setup.

  • The client machine can communicate to the DB2 server.

Then you're ready to install the DB2 product, using the DB2 Setup Wizard (or execute the db2setup command at the UNIX command prompt), assuming that the server has been set up, the instance has been started, and the sample database has been created.

After DB2 client successfully installed, you should configure it to access the remote DB2 server using the Configuration Assistant or using 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 the Configuration Assistant.

or

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

      db2 catalog tcpip node node_name remote hostname   server service_name   db2 catalog tcpip node nphantom remote 192.168.1.51   server 50000  
  • 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 sample as rsample   at node nphantom authentication server  
  • Test the client-server connection:

      db2 connect to rsample user v8inst   db2 "select tabname from syscat.tables"   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

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net