home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  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 FixList