DB2 - Problembeschreibung
Problem IC77520 | Status: Geschlossen |
DB2 MAY TRAP OR HANG WHEN THE TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL KEYWORD IS USED WITH A TRUSTED ROUTINE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problembeschreibung: | |
When TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL is set and a trusted routine is called it may cause the db2 instance to hang or crash. The following stack is an example or what has been observed: 0x09000000062a01a0 SqloMemoryProtectionEDU::enterSignalHandler()(??) + 0x20 <signal> 0x09000000062a01a0 SqloMemoryProtectionEDU::enterSignalHandler()(??) + 0x20 <signal> 0x09000000045a4b40 fdprpro_symbol_fixer_5__fdpr_57(??) + 0x12c 0x09000000045a4850 MemGetThrd__fdpr_1(??, ??, ??) + 0x20 0x09000000041a5388 sqloMemFreePools(0x9001000a0c4f350, 0x0) + 0xac 0x0900000004107afc sqloExitAppThread() + 0x34 0x0900000004194964 CLI_cpTraceRefreshMon(??) + 0xbc 0x09000000003594f4 _pthread_body(??) + 0xdc | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Any using TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL in CLI * **************************************************************** * PROBLEM DESCRIPTION: * * When TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL is set and a * * trusted routine is called it may cause the db2 instance to * * hang or crash. * **************************************************************** * RECOMMENDATION: * * Update to DB2 v9.8 Fixpack 4 or later * **************************************************************** | |
Local-Fix: | |
Unset the keyword to avoid this issue. | |
verfügbare FixPacks: | |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux | |
Lösung | |
Problem was first fixed in DB2 v9.8 Fixpack 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.07.2011 04.08.2011 04.08.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.8.FP4 | |
Problem behoben lt. FixList in der Version | |
9.8.0.4 |