DB2 - Problem description
Problem IC81612 | Status: Closed |
ZERO LENGTH DRDA DDM MONITORRD CRASHES DB2 INSTANCE. | |
product: | |
DB2 CONNECT / DB2CONNCT / 910 - DB2 | |
Problem description: | |
The instance may trap because of empty DRDA DDM MONITORRD reply returned by the server. The stack may look like as below. The defect causes memory corruption can corrupt the stack. sqlomcpy() ## Stack corrupted sqljcReadBytes() ## Stack corrupted sqljrParseMonitorRd() ## Stack corrupted sqljrParseOpenSuccessReply() ## Stack corrupted sqljrParseOpenQueryReply() sqljrParse() sqljrDrdaArOpen() sqljs_ddm_opnqry() sqljsParseRdbAccessed() sqljsParse() sqljsSqlam() sqljsDriveRequests() sqljsDrdaAsInnerDriver() sqljsDrdaAsDriver() RunEDU() Trace buffer from zDB2 V10: 6132 data DB2 UDB DRDA Communication Manager sqljcIntReceive fnc (3.3.54.4.0.1178) 6132 data DB2 UDB DRDA Communication Manager sqljcIntReceive fnc (3.3.54.4.0.1178) 63C0 202000104C434E44 4444312020202020 ..LCNDDD1 ....<.+......... 63D0 2020202000000000 FF000AD003000200 ............ ...........}.... 63E0 041C00 Trace Snippet: 6259 | | | | | | | | | | | sqljrParseMonitorRd entry [eduid 5399 eduname db2agent] 6260 | | | | | | | | | | | | sqljcReadUint16Split entry [eduid 5399 eduname db2agent] 6261 | | | | | | | | | | | | | sqljcReadDssContLen entry [eduid 5399 eduname db2agent] 6262 | | | | | | | | | | | | | | pdLog entry [eduid 5399 eduname db2agent] 6263 | | | | | | | | | | | | | | | pdLogInternal entry [eduid 5399 eduname db2agent] 6264 | | | | | | | | | | | | | | | | sqltGetDiagPath entry [eduid 5399 eduname db2agent] 6265 | | | | | | | | | | | | | | | | sqltGetDiagPath data [probe 10] 6266 | | | | | | | | | | | | | | | | sqltGetDiagPath exit 6267 | | | | | | | | | | | | | | | | pdIsFODCInProgress entry [eduid 5399 eduname db2agent] 6268 | | | | | | | | | | | | | | | | pdIsFODCInProgress exit 6269 | | | | | | | | | | | | | | | | pdIsEduFODCInProgress entry [eduid 5399 eduname db2agent] 6270 | | | | | | | | | | | | | | | | pdIsEduFODCInProgress exit 6271 | | | | | | | | | | | | | | | pdLogInternal exit 6272 | | | | | | | | | | | | | | pdLog exit 6273 | | | | | | | | | | | | | sqljcReadDssContLen exit [rc = 0x87360009 = -2026504183 = SQLJC_ERROR_BEOF] 6274 | | | | | | | | | | | | sqljcReadUint16Split exit [rc = 0x87360009 = -2026504183 = SQLJC_ERROR_BEOF] 6275 | | | | | | | | | | | | sqljcReadUint16Split entry [eduid 5399 eduname db2agent] 6276 | | | | | | | | | | | | sqljcReadUint16Split exit [rc = 0x87360009 = -2026504183 = SQLJC_ERROR_BEOF] 6277 | | | | | | | | | | | | sqloEDUCodeTrapHandler entry [eduid 5399 eduname db2agent] --------- An application may also receive the error message: SQL0902C reason code = "9" SQLSTATE=58005 This error message would occur if the application is running on the DB2 Connect server directly and if the db2set registry parameter DB2CONNECT_IN_APP_PROCESS=NO is set. This specific problem is related to this APAR and the issue is more prevalent if a query is issued against the server that returns multiple rows (possibly over 500 rows). Removing DB2CONNECT_IN_APP_PROCESS=NO (or setting it to YES) may workaround this particular instance of the issue. | |
Problem Summary: | |
Users Effected: This problem effects all users. Problem Description: ZERO LENGTH MONITORYRD CRASHESE DB2 INSTANCE. Problem Summary: ZERO LENGTH MONITORYRD CRASHESE DB2 INSTANCE. | |
Local Fix: | |
Solution | |
Workaround | |
Upgrade to DB2 Version Version 9.1, FixPak 12. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.02.2012 17.01.2013 15.05.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.12 |