DB2 - Problembeschreibung
Problem IC68534 | Status: Geschlossen |
INSTANCE MAY CRASH WHEN STATEMENT MONITOR IS ON AND LOTS OF QUERIES INCLUDING SOME SAME QUERIES ARE PREFORMED CONCURRENTLY. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
Instance may crash with the following stacks when the statement monitor is on and lots of queries including some same queries are preformed concurrently on the federated environment. <StackTrace> -------Frame------ ------Function + Offset------ 0x000000000000F498 ?unknown + 0x0 0x090000000577253C locate_or_add_stmt__18sqlqg_remote_stmtsFP24sqlqg_anchor_remote_ stmtPUciPP30sqlqg_remote_stmt_monitor_info + 0x314 0x090000000579D96C rollup__18sqlqg_remote_stmtsFP30sqlqg_remote_stmt_monitor_info + 0x84 0x0900000004175CC4 @79@sqlqg_rollup_remote_stmt__FP8sqeAgentPcP30sqlqg_remote_stmt_ monitor_info + 0x1F8 0x0900000004136AEC sqlqgClose__FP12sqlri_rquerys + 0x834 0x09000000041361FC sqlqgClose__FP12sqlri_rquerys@glue710 + 0x74 0x0900000005E8C3F0 sqlricjpInfrequent__FP8sqlrr_cbPP12sqlri_opparml + 0x204 0x090000000606299C sqlricjp__FP8sqlrr_cbP12sqlri_opparmilT4 - 0x1D0 0x090000000608F53C sqlricls_complex__FP8sqlrr_cbilN23 - 0x590 0x0900000006090440 @87@sqlricls__FP8sqlrr_cbiN32 + 0x64 0x0900000006200250 sqlrr_process_close_request__FP8sqlrr_cbiN32 + 0xE4 0x0900000003D5FC0C sqlrr_process_close_request__FP8sqlrr_cbiN32@glueD7B + 0x80 0x0900000004CE8BA0 sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0x23C 0x0900000006203DD8 sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0x910 0x090000000620344C sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x4 0x090000000604FD3C .sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface_fdprpro_clone_15 6 + 0x278 0x0900000006036330 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x4BC 0x0900000005EF4464 @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 0x0900000005EF42CC @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 0x0900000005EF3CF0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xD8 0x0900000006175D4C RunEDU__8sqeAgentFv + 0x13C 0x0900000006175A94 EDUDriver__9sqzEDUObjFv + 0x94 0x090000000617BCAC sqloEDUEntry + 0x4 </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * As same as Error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.1 FixPack 10. * **************************************************************** | |
Local-Fix: | |
Turn off the statement monitor. | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.1 FixPack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.05.2010 16.06.2011 16.06.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP10 | |
Problem behoben lt. FixList in der Version | |
9.1.0.10 |