DB2 - Problembeschreibung
Problem IC64170 | Status: Geschlossen |
SET WRITE SUSPEND ON A BUSY DATABASE CAN HANG FOR A VERY LONG TIME, WAITING ON THE PAGECLEANERS GETTING PAUSED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The SET WRITE SUSPEND session is waiting in the following stack: (6) 0xc00000000032f310 _semtimedop_sys + 0x30 [/usr/lib/hpux64/libc.so.1] (7) 0xc00000000033d870 _semtimedop + 0xb0 [/usr/lib/hpux64/libc.so.1] (8) 0xc00000000915ce10 sqloWaitEDUWaitPost + 0x350 [/opt/IBM/db2/V8.1/lib64/libdb2e.so] (9) 0xc00000000a125170 _Z21sqlbPauseCleanerGroupP20SQ + 0x5f0 [/opt/IBM/db2/V8.1/lib64/libdb2e.so] (10) 0xc00000000a125e50 _Z20sqlbPauseAllCleanersP12SQLB + 0x170 [/opt/IBM/db2/V8.1/lib64/libdb2e.so] (11) 0xc00000000a1f6ae0 _Z16sqlbSuspendWritetP12SQLB_GLOBALS + 0x350 [/opt/IBM/db2/V8.1/lib64/libdb2e.so] (12) 0xc00000000a1fc990 _Z17sqlbSetPoolChangeP5sqldaS0_P5sqlca + 0x1150 [/opt/IBM/db2/V8.1/lib64/libdb2e.so] ... Page cleaners still can need a long time to be paused on busy databases and bufferpools. This is a continuation of APAR IZ25687. | |
Problem-Zusammenfassung: | |
USERS AFFECTED: All PROBLEM DESCRIPTION: See ERROR DESCRIPTION PROBLEM SUMMARY: See ERROR DESCRIPTION | |
Local-Fix: | |
Do not run SET WRITE SUSPEND, while there is load on the database. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 2 | |
Workaround | |
See LOCAL FIX. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.10.2009 08.06.2010 08.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |