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 IC61781 Status: Geschlossen

ALTER BUFFERPOOL REDUCE OR STMM MAY HANG IF SET WRITE SUSPEND HAD BEEN
ISSUED

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
SET WRITE SUSPEND has the ability to interrupt page cleaners, 
but once the page cleaners had been interrupted, they did not 
perform the correct sequence of disengagement, and may cause 
ALTER BUFFERPOOL REDUCE or STMM to indefinitely wait on some 
page latches.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* For users of STMM or SET WRITE SUSPEND, db2stop force may    * 
* hang                                                         * 
* For other users, they may experience a slow or inefficient   * 
* page cleaning on a busy system.  This could lead to log      * 
* space being held up by dirty pages, or a higher than usual   * 
* dirty steals occurring in the bufferpool, which could affect * 
* performance.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to the aforementioned fixpaks.                       * 
****************************************************************
Local-Fix:
Recycle the instance
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
The problem has been fixed in v91 fp 8, v95 fp5 and v97 fp1 
 
As part of the change, the set write suspend command may take 
longer to pause the page cleaners than v91 fp7/v95 fp4 when the 
problematic APAR went in.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC64767 IC64825 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.06.2009
10.12.2009
10.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP7/v95,
9.1.FP8,
9.5.FP5,
9.7.FP1
Problem behoben lt. FixList in der Version
9.1.0.8 FixList