DB2 FOR LUW / DB2FORLUW / 970 - DB2

Due to a logic error, STMM does not cost SORT operations for 
index creation during the initial "insert" phase. 
As a result, SORTHEAP may not be tuned appropriately. 
This impacts longer index creations which may benefit from 
higher SORTHEAP settings. 
Activities impacted include LOAD, REORG, CREATE INDEX.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Systems running with STMM enabled to tune SORTHEAP           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to Version 9.7, Fix Pack 5                           * 
****************************************************************

Manually tune SORTHEAP, SHEAPTHRES_SHR to desired values if the 
database is configured for AUTOMATIC Sort tuning. 
It is possible to do this dynamically with a database 
connection, and return to AUTOMATIC after the activity involving 
index creation is complete.

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
 

Problem first fixed in DB2 Version 9.7 Fix Pack 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.03.2011
24.02.2012
24.02.2012

9.7.FP5