IBM Support

DB2 : Too many dump files in DIAGPATH post SQLJS_DTAMCH errors messages in db2diag.log

Troubleshooting


Problem

Too many dump files are created after the below errors reported in db2diag.log  :
yyyy-mm-dd-15.50.43.129076+480 E148945945A813       LEVEL: Error
PID     : 17301582             TID : 62193          PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   : DB01
APPHDL  : 0-24195              APPID: xx.xxx.xx.xxx.xxxxx
AUTHID  : DB2USR               HOSTNAME: xxxxx
EDUID   : 62193                EDUNAME: db2agent (DB01) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseSqlSttGrpNOC, probe:418
MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected. 
The diagnostic           data returned is (SRVDGN): "FUNCTION ID = 0052 , PROBE POINT = 0418 ,          
TRACE POINT = 0040 , SUBCODE1 = FFFFFFFF804B009D, SUBCODE2 =           0000000000000A38,
SUBCODE3 = 0000000000000000, ERROR MSG = Parser:           Invalid value".
yyyy-mm-dd-15.50.43.129575+480 I148946759A710       LEVEL: Error
PID     : 17301582             TID : 62193          PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   : DB01
APPHDL  : 0-24195              APPID: xx.xxx.xx.xxx.xxxxx
AUTHID  : DB2USR               HOSTNAME: xxxxx
EDUID   : 62193                EDUNAME: db2agent (DB01) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseSqlSttGrpNOC, probe:40
MESSAGE : ZRC=0x804B009D=-2142568291=SQLJS_DTAMCH        
   "Error during reading of FDOCA data"
DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 16 bytes   
data length : 2622     
codepoint   : 0x2414 ( SQLSTT )     
length      : 2626 ( COMPLETE )
yyyy-mm-dd-15.50.43.129963+480 I148947470A190     LEVEL: Error
PID:17301582 TID:62193 NODE:000
Title: **** DRDA ASCB **** Dump File:/DIAGPATH/17301582.62193.000.dump.bin
Such errors keep repeating and dumping files with information about the error.

Symptom

There are lots of dump files in DIAGPATH.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PkrAAE","label":"Programming Interface"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

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

ibm16398646