Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC67239 Status: Closed

POSSIBLE HANG DUE TO INFINITE LOOP IN SQLMON_CONN::LOOKUP_STMT()

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
There is a possible hang situation due to one agent looping in 
sqlmon_conn::lookup_stmt() holding the 
SQLO_LT_sqlmon_conn__rds_latch. 
 
Here is a typical stack: 
 
EDU name     : db2agent (XXXXXX) 0 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x09000000065C8784 
lookup_stmt__11sqlmon_connCFPCUcN21CUsN24CUiT4CbT7 + 0x11C 
0x09000000065D2E80 
stmt_start__11sqlmon_connFRC8sqeAgentCUiPCUcN23CUsN26T2T6N22CiT1 
3_RP11sqlmon_stmtRP10sqlmon_uow + 0x474 
0x090000000688A27C 
agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N35N21CiP8sqlrr_cb 
+ 0x1394 
0x09000000068909F0 
agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N35N21CiP8sqlrr_cb 
@glue921 + 0xD0 
0x0900000004E072CC 
sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP 
15db2UCCursorInfo + 0x7C 
0x0900000004E0359C sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo 
- 0x148 
0x0900000007E481E4 executeSection__10pvmPackageFP5sqlcaUi + 
0x870 
0x0900000007E449BC executeQuery__3PVMFUi + 0xEC 
0x0900000007E4421C run__3PVMFv + 0x9BC 
0x0900000007E42508 pvm_entry + 0x314 
0x0900000004E232F4 sqloInvokeFnArgs + 0xC0 
0x0900000004FC2DB0 sqloInvokeFnArgs@glue5F9 + 0x74 
0x0900000005129178 
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf + 
0xD14 
0x0900000004F1BE04 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90 
0x09000000052C2EFC sqlricall__FP8sqlrr_cb + 0x7C 
0x0900000004DCAA40 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 
0x788 
0x0900000004DF8ACC sqlrr_process_execute_request__FP8sqlrr_cbi + 
0x344 
0x0900000004E03744 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo 
+ 0x60 
0x0900000007E481E4 executeSection__10pvmPackageFP5sqlcaUi + 
0x870 
0x0900000007E449BC executeQuery__3PVMFUi + 0xEC 
0x0900000007E4421C run__3PVMFv + 0x9BC 
0x0900000007E42508 pvm_entry + 0x314 
0x0900000004E232F4 sqloInvokeFnArgs + 0xC0 
0x0900000004FC2DB0 sqloInvokeFnArgs@glue5F9 + 0x74 
0x0900000005129178 
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf + 
0xD14 
0x0900000004F1BE04 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90 
0x09000000052C2EFC sqlricall__FP8sqlrr_cb + 0x7C 
0x0900000004DCAA40 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 
0x788 
0x0900000004DF8ACC sqlrr_process_execute_request__FP8sqlrr_cbi + 
0x344 
0x0900000004E03744 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo 
+ 0x60 
0x0900000004E086A4 
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x8B0 
0x0900000004E08FAC 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x78 
0x0900000004E08DC0 
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 
0x0900000004E0A3F0 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x224 
0x0900000004ED3EF8 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 
0x0900000004ED3C04 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 
0x0900000004ED398C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x13C 
0x0900000004EB0850 RunEDU__8sqeAgentFv + 0x11C 
0x0900000004EB05B0 EDUDriver__9sqzEDUObjFv + 0x94 
0x0900000004EAB2EC sqloEDUEntry + 0x54C 
</StackTrace> 
 
<LatchInformation> 
Holding Latch type: (SQLO_LT_SQLP_TENTRY__applLatch) - Address: 
(700000dfb783e08), Line: 709, File: sqlpxreg.C 
Holding Latch type: (SQLO_LT_sqlmon_conn__rds_latch) - Address: 
(7800000020f7978), Line: 368, File: sqlmacb.C 
</LatchInformation>
Problem Summary:
USERS AFFECTED: All 
 
PROBLEM DESCRIPTION: 
 
see ERROR DESCRIPTION 
 
PROBLEM SUMMARY: 
 
see ERROR DESCRIPTION
Local Fix:
n/a
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The complete fix for this problem first appears in DB2 UDB 
Version 9.5 FixPak 6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC67240 IC67724 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.03.2010
14.05.2010
14.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.