|
Problem IC86813
|
Status: Geschlossen |
AUTOMATIC TUNING OF LINUX KERNEL.SHMALL PARAMETER INCORRECTLY ASSUMES THAT PAGE SIZE IS 4K |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Upgrade to DB2 10.1 fixpack 2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.09.2012
29.01.2013
29.01.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
