Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Wink Unanswered: Adding System in Client

    hi i have installed db2 client in my Xp system.

    i want to add the system and the databases.
    i tried using CA and when searching for the known system....
    my server is not been shown and all my databases are in cloud on top of my server...

    help me as how to add the system and database.

    thanks in advance.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You will need the following info:

    • ip address or host name of server
    • Port number of DB2 instance
    • database name on server
    • database name you want to use on the client (alias) if different


    Then refer to the Command Reference Manual for the following commands:
    • catalog tcpip node
    • catalog database

    You could also do this manually with the CA (instead of using discover).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Thumbs down

    thanks

    i have my server Ip say in 192.0.0 network
    and my cloud Ip is 10.20... network where the DB2 is installed

    when i give system name / Ip of the cloud it is not recognizing

    if i give the Hostname and that ask for the service name... i don know how to find the service name ...

    it is throwing an error as displayed
    Attached Thumbnails Attached Thumbnails client error.bmp  

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Ask someone who is a DBA for that remote database what the service name or port number is for that DB2 instance. This information can be found by logging on to the database server as the instance owner and typing the following command:

    db2 get dbm cfg

    TCP/IP Service name (SVCENAME) = 50000

    If it is a number, then it is a port number, or if alphanumeric it is a service name resolved in /etc/services (or windows equivilent for windows based servers).

    The default port number is 50000 in most cases (if you can't get someone to help you and want to guess).

    If you cannot log on to the server as instance owner, try looking in the /etc/services file for the port number (should be near the bottom).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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