Timeout(30000) waiting for the DB2-DB2 service to connect.

Posted on 2006-05-11
Last Modified: 2010-08-05
DB2 Service not starting on system reboot, when set start to automatic.
But works fine, when it is started manually.
Machine is Win2k SP4 and did Windows Updates as well
FixPack 5 is applied to DB2 8.1

Event Log shows 2 Error messages, source as Service Control Manager.

Timeout(30000) waiting for the DB2-DB2 service to connect.
The service did not respond to the start or control request in a timely fashion

Anybody have any clue into it.

Question by:Aneesh Retnakaran
    LVL 7

    Expert Comment

    Any info in db2diag.log?
    LVL 75

    Author Comment

    by:Aneesh Retnakaran
    Sorry for this delayed reply.. actually One of my friends asked this question, and he is now on vacation. I will send the log information as soon as he comes...
    LVL 7

    Expert Comment

    LVL 75

    Author Comment

    by:Aneesh Retnakaran
    hi, this is what i got

    This is the error repeatedly showing in DB2Diag.log
    2006-05-08-   Instance:DB2   Node:000
    PID:664(DataTestService.exe)   TID:756   Appid:none
    oper system services  sqloSSemClose Probe:20

    Unexpected system error 0x6 has occurred.
    This has been mapped to ZRC 0x83000006.

    PID:664 TID:756 Node:000 Title: SYSTEM ERROR DESCRIPTION
    The handle is invalid.

    This "DapTestService.exe" is a windows service that connects to DB2 using ODBC.
    Its also noticed that, this service takes a lot of memory, when DB2 is stopped.
    Is it that ODBC connection is takingup a lot of memory when trying to connect to DB2?
    LVL 7

    Expert Comment

    check you dbm cfg, tune memory properly. If possible upgrade to FP7+

    I have seen couple of more post with similar error with FP5  on Win2k.

    Input ZRC string '0x83000006' parsed as 0x83000006 (-2097151994).

    ZRC value to map: 0x83000006 (-2097151994)
            V7 Equivalent ZRC value: 0xFFFFB006 (-20474)

    ZRC class :
            Unexpected Operating System error (Class Index: 3)
            Unknown component (Component Index: 0)
            Undefined as of DB2 v8.1.11.973; s060120
    Operating system reason code (GetLastError) : DWORD error = 6 -- The handle is invalid.

    Attempting to lookup value 0x83000006 (-2097151994) as a sqlcode
            No sqlcode message found for value -2097151994
    LVL 75

    Author Comment

    by:Aneesh Retnakaran
    still no use...
    LVL 13

    Accepted Solution

    win 2k start errors for db2 are almost always related to bad or corrupt install. The reason is the service is improperly cataloged in the win2k registry, or has multiple entries for same instance name. Therefore, on re boot, doesnt know which instance to start.
    but when you start from services panel, the instance name is directly mapped to the registry entry, hence, windows knows which service to start.
    one way to fix this error is to drop the current instance and create a new one.
    make sure your new instance name is not the same as the previous instance name.
    after creating new instance, re catalog the databases.
    test out new instance by re booting machine, making sure that the service is set to auto.

    other possibility:
    re set the password for the db2 service to match the existing passowrd for the service owner. Somebody may have changed the password for the service owner without you knowing, hence 'invalid handle'

    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

    Join & Write a Comment

    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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    755 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

    18 Experts available now in Live!

    Get 1:1 Help Now