DB2 - Problembeschreibung
Problem IC90452 | Status: Geschlossen |
DB2 MIGHT CRASH WHEN RUNNING DBMS_ALERT.SET_DEFAULTS() SQL FUNCTION. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
It is possible that DB2 can crash when the system module function DBMS_ALERT.SET_DEFAULTS() routine is run. The function takes a single argument (the polling interval that you want to set for use with other DBMS_ALERT module functions), but the actual value chosen as the input argument does not influence the chances of hitting this trap. The following is an example stack traceback that you might see if this trap is encountered: 0x09000000407BC0E0 sqlemlGetModuleCb__F13sqlrSysModulePPvPb + 0x80 0x09000000407BC1C0 packageStateGet__F13sqlrSysModulePb + 0x40 0x09000000407BC344 getSessionState__Fv + 0x124 0x09000000407BE79C sqleml_dbms_alert_set_defaults + 0x13C 0x0900000028D2077C sqloInvokeFnArgs + 0x11C 0x090000002A909054 sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0xD74 0x090000002A91D930 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x5F0 0x090000002A9216D4 sqlricall__FP8sqlrr_cb + 0x8F4 0x0900000029742150 sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm + 0x5D0 0x0900000029744374 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0xE34 0x0900000029AE9810 sqlrr_process_execute_request__FP8sqlrr_cbib + 0x1CF0 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v101 FP3 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Fix will be available in v101 FP3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.02.2013 27.09.2013 27.09.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |