|
Problem IC86813
|
Status: Closed |
AUTOMATIC TUNING OF LINUX KERNEL.SHMALL PARAMETER INCORRECTLY ASSUMES THAT PAGE SIZE IS 4K |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Starting in DB2 9.7 Fix Pack 2 and DB2 9.5 Fix Pack 6, the
database manager uses a new formula to automatically adjust
kernel parameter settings:
kernel.shmall (SHMALL) = 2 * <size of RAM in 4k pages>
During the starting of the DB2 instance, DB2 on Linux updates
the kernel parameter SHMALL to a size equal to double the size
of RAM. However in this calculation DB2 assumes the Linux
default memory page size is equal to 4k. This assumption is not
correct on a system where the default memory page size is not
4k, such as on a system with
a 64k page size.
As a result , the calculated kernel parameter shmall may be too
big. Please note that this fact itself doesn't cause any problem
for DB2, and the instance should start normally.
The formula has been adjusted as follows:
kernel.shmall (SHMALL) = 2 * <size of RAM in the default
system page size> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* Starting in DB2 9.7 Fix Pack 2 and DB2 9.5 Fix Pack 6, the *
* database manager uses a new formula to automatically adjust *
* kernel parameter settings: *
* *
* kernel.shmall (SHMALL) = 2 * <size of RAM in 4k pages> *
* *
* During the starting of the DB2 instance, DB2 on Linux *
* updates *
* the kernel parameter SHMALL to a size equal to double the *
* size *
* of RAM. However in this calculation DB2 assumes the Linux *
* default memory page size is equal to 4k. This assumption is *
* not *
* correct on a system where the default memory page size is *
* not *
* 4k, such as on a system with *
* a 64k page size. *
* *
* As a result , the calculated kernel parameter shmall may be *
* too *
* big. Please note that this fact itself doesn't cause any *
* problem *
* for DB2, and the instance should start normally. *
* *
* The formula has been adjusted as follows: *
* kernel.shmall (SHMALL) = 2 * <size of RAM in the default *
* system page size> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 fixpack 2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to DB2 10.1 fixpack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.09.2012
29.01.2013
29.01.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
