Thursday, 5 April 2012

Install and Configure DB2 client locally to connect to remote db2 server

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.
  • 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  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

No comments:

Post a Comment

Tweets by @sriramperumalla