Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2013

    Thumbs up Unanswered: SQL30081N Error - 10061 error code

    I am getting SQL30081N error while connecting to the database from an URL. I am using DB2 version 9.5 in UNIX AIX server...

    I am able to connect to the database in UNIX AIX server and I am seeing no problem in connecting ti the database in UNIX terminal. But developers sayin tat tey could not access the database thro an URL. I checked the following things from DB side:
    1. db2COMM registry variable is set to TCPIP
    2. correct port no is assigend.
    $db2 get dbm cfg | grep -i svce
    $more /etc/services | grep -i db2ckeuaapl1
    The port no is also assigned correctly.
    3. The database manager is running.
    4. netstat -an | grep 60136 >> The port is Listening only...

    I still could not figure about what the problem is. Please help me how to resolve this error? Do i need to check anything more in DB side apart from the above things?

    Any help is much appreciated. Thanks.

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    Try the telnet command mentioned here:
    IBM SQL30081N TCPIP communication errors - United States

    and check catalog info on the client machine.

  3. #3
    Join Date
    Jul 2013

    Thumbs up Re:SQL30081N Error - 10061 error code

    Hi Thanks for the response. I tried the following command:
    telnet hostname port_no.... but it is neither fetchin results nor errors... I did not get any reulst output in the screen... wat does it mean? Does it mean that it is unalbe to connect to the server using the port??


  4. #4
    Join Date
    Apr 2006
    Provided Answers: 11
    no - db2 is not serving a telnet appl
    if no error - means you can connect to the port (so db2 is listening)
    there is another problem
    has this worked before or new installation ?
    firewall ?
    do you have a regular client somewhere ? try to catalog the db and connect
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  5. #5
    Join Date
    Jul 2013

    Re:SQL30081N Error - 10061 error code


    the probelm is resolved now... The problem is with winidows network firewall.. In Windows side the port details are not present in the windows firewal... thanks for ur help.

Posting Permissions

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