How to interpret db2diag

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hype - 26 Feb 2005 04:36 GMT

PID : 7031 TID : 3007211424 PROC : db2start
INSTANCE: db2inst8 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbFreeCmdHandle, probe:10
MESSAGE : Error closing socket, OSSrc =
DATA #1 : Hexdump, 4 bytes
0xBFFF6B1C : 2500 0F87

How do we intepret the last line ?
How can I lookup error messages for these values ?

TIA,
Hype.

Reply to this Message

Larry - 26 Feb 2005 14:29 GMT

I don't know if these msgs are actually documented. When you see errors
like this, it is generally time for a PMR with IBM support ... the
service team is generally the best place to go with this.

Larry Edelstein

> PID : 7031 TID : 3007211424 PROC : db2start
> INSTANCE: db2inst8 NODE : 000
[quoted text clipped - 8 lines]
> TIA,
> Hype.

Reply to this Message

Philip Nelson - 26 Feb 2005 23:48 GMT

It is well hiddent but these hex codes ARE actually documented on the IBM
site for V8 (for V7 they used to be in the Troubleshooting Guide, but that
is no more).

http://www-1.ibm.com/support/docview.wss?uid=swg21066178

Phil

> I don't know if these msgs are actually documented. When you see errors
> like this, it is generally time for a PMR with IBM support ... the
[quoted text clipped - 14 lines]
>> TIA,
>> Hype.

Reply to this Message

Larry - 27 Feb 2005 01:03 GMT

Thanks, Phil!

Larry

> It is well hiddent but these hex codes ARE actually documented on the IBM
> site for V8 (for V7 they used to be in the Troubleshooting Guide, but that
[quoted text clipped - 22 lines]
>>>TIA,
>>>Hype.

Reply to this Message

Steve Pearson - 28 Feb 2005 18:22 GMT

The output is influenced by byte order. I believe the following
is the entry for the code reported above:

---

Internal Return Codes - DB2 Version 8.1
Internal Return Codes
The following list is provided to help you interpret some of the
hexadecimal return codes you may encounter when analyzing
a db2diag.log. If you encounter a return code that is not in the
list, contact DB2 Customer Support.

Internal return code, Name, SQL code if applicable, Description
0x870F0025 -2029060059, SQLO_INVALID_MHANDLE, -902, Invalid File Handle

Reply to this Message