DB2 - Problembeschreibung
Problem IC72295 | Status: Geschlossen |
ENGINE CAN CRASH ON SQM_ADD_SS_COUNTERS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
DB2 can crash with the following stack if we have the Statement Monitor switch set to ON 0 sqm_add_ss_counters 1 sqm_take_stmt_snap 2 sqm_snap_appl 3 sqlmonssagnt 4 sqlmonssbackend 5 sqlesrvr 6 sqleMappingFnServer 7 sqlerKnownProcedure 8 sqlerCallDL 9 sqljs_ddm_excsqlstt.fdpr.clone.96 10 sqljsParseRdbAccessed 11 sqljsParse.fdpr.clone.1029 12 sqljsSqlam 13 sqljsDriveRequests 14 sqljsDrdaAsInnerDriver 15 sqljsDrdaAsDriver 16 sqeAgent::RunEDU 17 sqzEDUObj::EDUDriver 18 sqloEDUEntry | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * The problem is due to internally changing a structure * * without holding the latch for it. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.1 and Fix Pack 10 * **************************************************************** | |
Local-Fix: | |
Set Statement monitor switch to OFF (DFT_MON_STMT) and make sure that the Statement Monitor switch is not turned on for the sessions (db2 get monitor switches). Note that db2top -s Statement option has Statement Monitor switch turned on by default so using db2top to monitor Statements will make the system vulnerable to this APAR. | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Lösung | |
Problem was first fixed in DB2 Version 9.1 and Fix Pack 10 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.10.2010 10.06.2011 10.06.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1., 9.7. | |
Problem behoben lt. FixList in der Version | |
9.1.0.10 |