DIA5000C error with dump file
IBM Support
DIA5000C error with dump file
https://www.ibm.com/support/pages/dia5000c-error-dump-file-0
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.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
10.5, 11.1
Operating system(s):
AIX, HP-UX, Linux
Document number:
568891
Modified date:
16 June 2018
Contact IBMPrivacyTerms of useAccessibility
------------------------------------------------------------------------------------------
如果你觉得文章有用，欢迎打赏
