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 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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList