DB2 FOR LUW / DB2FORLUW / 970 - DB2

This issue will likely only be seen under special conditions 
such as: 
 
  1. DB2_USE_ALTERNATE_PAGE_CLEANING=ON 
  2. DB2_ENABLE_AUTOCONFIG_DEFAULT=NO 
  3. "create database" statement is special, for example: 
 
  db2 "create database test2 AUTOMATIC STORAGE NO using codeset 
UTF-8 territory US pagesize 16384 with 'xxxx.xxxx.xxxxxxx' 
AUTOCONFIGURE APPLY NONE" ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The issue will be found in critical conditions only:         * 
*                                                              * 
* 1. DB2_USE_ALTERNATE_PAGE_CLEANING=ON                        * 
* 2. DB2_ENABLE_AUTOCONFIG_DEFAULT=NO                          * 
* 3. "create database" statement is special, for example:      * 
*                                                              * 
* db2 "create database test2 AUTOMATIC STORAGE NO using        * 
* codeset UTF-8 territory US pagesize 16384 with               * 
* 'xxxx.xxxx.xxxxxxx' AUTOCONFIGURE APPLY NONE" ;              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97FP5 or higher version                      * 
****************************************************************

1. DB2_USE_ALTERNATE_PAGE_CLEANING=OFF 
or 
2. DB2_ENABLE_AUTOCONFIG_DEFAULT=YES 
or 
3. To rewrite the "create database" statement. 
 
  db2 "create database test2 AUTOMATIC STORAGE NO using codeset 
UTF-8 territory US with 'xxxx.xxxx.xxxxxxx' AUTOCONFIGURE APPLY 
NONE" ;

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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The APAR was fixed on DB2 V97FP5 and higher version

1. Avoid using "AUTOCONFIGURE NONE" in CREATE DB command to    l 
et DB2 pick the right values 
2. Or make other small changes to the CREATE DB command, such  a 
s changing the page size, tablespace types, etc: all of these  h 
ave an impact on timing, and the problem may go away.

forerunner  : APAR is sysrouted TO one or more of the following: IC75701 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.03.2011
02.01.2012
02.01.2012

9.5.FP5,
9.7.FP5