Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Question Unanswered: DB2 connection problem!!!!!!!!!!!

    HI every one...

    Can anyone explain me wat does this statement represents...

    "catalog tcpip node dbserver1node remote db2unixhost server db2server1"


    HOw to find out following things for Connecting DB2 database.

    Host name where the DB2 database server resides
    Node name
    Database name
    Database alias
    Database user id and password
    Service name from the /etc/services file on client and host


    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by Anitha_raj
    HI every one...

    Can anyone explain me wat does this statement represents...

    "catalog tcpip node dbserver1node remote db2unixhost server db2server1"


    HOw to find out following things for Connecting DB2 database.

    Host name where the DB2 database server resides
    Node name
    Database name
    Database alias
    Database user id and password
    Service name from the /etc/services file on client and host


    Thanks in advance
    See the following for the catalog statement:

    http://publib.boulder.ibm.com/infoce...e/r0001944.htm

    For the rest:
    1) host name is assigned by the Network Administrator
    2) Node name is arbitrary and created in the catalog statement above
    3) database name is assigned by the DBA
    4) Database alias is assigned during a different statement: CATALOG DATABASE (see manual)
    5) username and passwords are assigned by the DBA
    6) Service name is assigned by the DBA

    HTH

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •