DB2 - Problem description
Problem IC78715 | Status: Closed |
ZERO LENGTH DRDA DDM MONITORRD CRASHES DB2 INSTANCE. | |
product: | |
DB2 CONNECT / DB2CONNCT / 950 - 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 AFFECTED: * * All DB2 connect user using zDB2 V10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v9.5.9 or higher version. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
V9.5.9 fixes the trap issue. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC79562 IC81612 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.09.2011 28.03.2012 15.05.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |