DB2 FOR LUW / DB2FORLUW / 970 - DB2

Two problems will be fixed in the db2osconf tool for Solaris. 
 
1. Since version 9.5, shared memory virtual limits need to be 
higher than the existing recommendation of 90% * RAM for many 
standard configurations.  This is due to additional virtual 
shared memory preallocation per instance and database, and 
volatility in STMM environments with many multiple databases. 
 
2. A separate problem is that  the shmmax recommendation (size 
of a single segment) is reported in 4K units, not bytes.  The 
setting should be reported in bytes.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 on Solaris                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Local Fix                                                * 
****************************************************************

Set project.max-shm-memory to at least 2 X RAM, set shmmax to at 
least 1 X RAM

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

See Local Fix

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

21.03.2011
23.05.2012
23.05.2012

9.7.FP5