Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: SQL 30081N TCPIP commnication error

    Hi,

    We are facing TCPIP Communication error in DB2 Express C,

    Issue:

    There are 2 sites which we connecting with Public IP
    Site A: server
    Site B: Client

    we are facing the below mentioned error

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

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


    ODBC connection failed.
    [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "xxx.xxx.xxx.xxx". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=0800

    Kindly help me how to solve this.

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    It could be a firewall issue. Make sure the ping the IP and see how it goes.

  3. #3
    Join Date
    Nov 2009
    Location
    Bangalore
    Posts
    25
    Is the SVCENAME and DB2COMM set at the server ?

    db2 update dbm cfg using SVCENAME <service/port number>
    db2set DB2COMM=TCPIP
    db2stop
    db2start

    Regards,
    Sawan Gupta

Posting Permissions

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