IBM Support

DIA5000C error with dump file

Troubleshooting


Problem

Whenever Db2 logs a DIA5000C error in the db2diag.log and creates a dump file for no obvious reason, meanwhile applications got ADM2502C. The first suggestion to customers is to check the network, meaning reviewing OS logs of network layer and/or network router/switch infrastructure for possible errors. Even there is not clear errors from network, but there is a chance the data transmitted over the network got corrupted, causing the error.

Symptom

Example of DIA5000C error in db2diag.log

2018-03-14-19.12.08.558428-240 E12195757E791 LEVEL: Error
PID : xxx TID : 140610858116864 PROC : db2sysc
INSTANCE: xxx NODE : 000 DB :
APPHDL : xxx APPID: xxx
AUTHID : xxx HOSTNAME:xxx
EDUID : xxx EDUNAME: db2agent (instance) 2
FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, probe:410
MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected. The diagnostic
data returned is (SRVDGN): "FUNCTION ID = 0045 , PROBE POINT = 0410 ,
TRACE POINT = 0020 , SUBCODE1 = FFFFFFFF804B008D, SUBCODE2 =
000000000000C501, SUBCODE3 = 0000000000000000, ERROR MSG = Parser:
Invalid DDM length".

2018-03-14-19.12.08.559691-240 I12196549E665 LEVEL: Error
PID : xxx TID : xxx PROC : db2sysc
INSTANCE: xxx NODE : 000 DB :
APPHDL : xxx APPID: xxx
AUTHID : xxx HOSTNAME: xxx
EDUID : xxx EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, probe:20
MESSAGE : ZRC=0x804B008D=-2142568307=SQLJS_SYNTAX "SYNTAX ERROR"
DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 16 bytes

data length : 18446744073709551612 -> extremely large
codepoint : 0xc501 ( UNKNOWN )
length : 0 ( COMPLETE )

2018-03-14-19.12.08.615489-240 I12197215E200 LEVEL: Error
PID:xxx TID:xxx NODE:000 Title: **** DRDA ASCB ****
Dump File:/xxx/sqllib/db2dump/17627.28271.002.dump.bin



And from the function definition of sqljsParseInstVar, clearly the code is expecting data of length 0 but the receive buffer shows otherwise and the codepoint is also unknown codepoint : 0xc501 ( UNKNOWN )
So in this case, server got unexpected data/value from client by network, then generated one dump file.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"}],"Version":"10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

swg22015086

Page Feedback