Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2007
    Posts
    5

    Unanswered: connect IBM Control Center to remote dB

    Hi,

    Im using the Config assistant to connect a client to a remote server, when finished i get the error below, any ideas?

    I have run the 'CATALOG' cmds on the client e.g.

    db2 catalog tcpip node db2 remote 9.162.141.153 server 22
    db2 catalog database DBNAME as DBNAME at node db2
    db2 CATALOG DCS DATABASE DBNAME

    and can see the port is listening in netstat -a | more e.g.
    tcp 0 0 *:xcmccarth *:* LISTEN

    I haven't configured anything on the server side as dont have permissions, do I need to? but in the /etc/services file i can see the remote connection port is 446 which is the same as i config on the client,

    Error:
    SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "9.162.141.153". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    When you catalog the node on the client workstation, you need to supply the port for the DB2 instance on the server. This normally defaults to 50000. Run "db2 get dbm cfg" on the server as the instance an look for SVCENAME. This will either be the port name or the name in /etc/services.

    Andy

  3. #3
    Join Date
    Jul 2007
    Posts
    5
    Hi ARwinner,

    thanks for the reply,

    the actual catalog cmd used was

    db2 catalog tcpip node UNIX remote 9.162.141.153 server 446

    which ssigned the PORT = 446

    and from the db2 get dbm cfg
    TCP/IP Service name (SVCENAME) = xcmccarth
    which is on port 446

    and can see the port is listening in netstat -a | more e.g.
    tcp 0 0 *:xcmccarth *:* LISTEN


    and from the /ect/services file

    ddm-rdb 446/tcp # DDM-Remote Relational Database Access
    ddm-rdb 446/udp # DDM-Remote Relational Database Access


    it all looks okay eh?
    but the connect on the server fails

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the output of this command on the server:

    cat /etc/services | grep -i xcmccarth

    Andy

  5. #5
    Join Date
    Jul 2007
    Posts
    5
    db2dev03 /etc> cat /etc/services | grep -i xcmccarth
    db2dev03 /etc>

    nothing returned...

  6. #6
    Join Date
    Jul 2007
    Posts
    5
    but in the configuration assistant on step two..

    Specify TCP/IP communication parameters

    Hostname: 9.162.141.155
    Sevice name: xcmccarth

    the retrieve button finds the entry 'xcmccarth' and returns 446 for the port number, Is this from the services file?

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I tend not to use the configuration assistant mainly because it supplies the node name as something totally non-meaningful.

    Supplying the SVCENAME instead of the port number, I believe will have the system look into the /etc/services file for the port of the name specified. In your case, it does not exist.

    Andy

  8. #8
    Join Date
    Dec 2008
    Posts
    76
    446 is a port used by DB2 Connect for mainframe connection
    Last edited by rdutton; 08-25-09 at 12:44.
    RD

Posting Permissions

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