SQL30081N - Protocol specific error code(s): "10055", "*", "*".  SQLSTATE=08001

Posted on 2009-12-29
Last Modified: 2012-05-08
When I try connect to a cataloged DB I get this error:

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

The database resides on AIX server. I have cataloged it on a windows server.
Question by:jsaravana
    LVL 37

    Expert Comment

    were you able to connect to it in the past or is this a new database?

    did you check that the instance is up and running?
    did you check that your firewall does not block the ports used by DB2 ?

    Author Comment

    This is the first time we are cataloging this database.

    The instance is up n running.

    I am not sure if any firewall is blocking the connection
    LVL 37

    Accepted Solution

    the most simple approach to check:
    using ip addr + port number, try this from your station:

    telnet ip-addr port

    if you can't use telnet, then your ports are probably blocked
    you can also try to connect and in the same time run

    netstat -an

    if you see that your connect attemp (you can find it by the ip and port of the db2 serveR) has status SYN_SENT
    it mean you have some kind of firewall blcok

    Author Comment


    Now I am able to connect, I had some tablespace issue in other database which was requesting for backup.
    When I took offline backup and tried connecting I was able to connect.

    Those were found in system error logs.

    I will try and find out you suggestions as well. Will be useful for me.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now