Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC61781 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
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 Summary:
**************************************************************** 
* 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
available fix packs:
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

Solution
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
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC64767 IC64825 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.06.2009
10.12.2009
10.12.2009
Problem solved at the following versions (IBM BugInfos)
9.1.FP7/v95,
9.1.FP8,
9.5.FP5,
9.7.FP1
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.8 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.