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

    Thumbs up Unanswered: SQL30081N Error - 10061 error code

    Hi,
    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
    db2ckeuaapl1
    $more /etc/services | grep -i db2ckeuaapl1
    60136
    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
    Location
    Toronto, Canada
    Posts
    2,367
    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
    Posts
    3

    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??

    Thanks.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    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
    http://www.infocura.be

  5. #5
    Join Date
    Jul 2013
    Posts
    3

    Re:SQL30081N Error - 10061 error code

    Hi,

    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
  •