home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC64081 Status: Closed

THE INSTANCE_MEMORY LIMITS INCREASED IN DB2 9 AND 95 ARE NOT REF LECTED IN
CONTROL CENTER.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In the control center, under DBM Configuration, the 
INSTANCE_MEMORY limits are set to that of DB2 v8, i.e. 
Range (8 - 524288) Pages (4Kb).  If you try to change it 
beyond this limit, the user would get an error. 
. 
In Db2 9 and 95, the limits should be: 
. 
v9 - (8 -- 4 294 967 295) Pages (4kb) 
v95 - 32-bit platforms [0 - 1 000 000] 
    - 64-bit platforms[0 - 68 719 476 736] 
.
Problem Summary:
In the control center, under DBM Configuration, the 
INSTANCE_MEMORY limits are set to that of DB2 v8, i.e. 
Range (8 - 524288) Pages (4Kb).  If you try to change it 
beyond this limit, the user would get an error. 
. 
In Db2 9,95 and 97 the limits should be: 
. 
v9 - (8 -- 4 294 967 295) Pages (4kb) 
v95 - 32-bit platforms  0 - 1 000 000
Local Fix:
you  can change the setting using update dbm cfg command.
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
apar IC64081 
module db2tools 
fixed >= v97 fpk1
Workaround
you  can change the setting using update dbm cfg command.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.10.2009
01.03.2010
01.03.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FPk1
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList
9.7.0.2 FixList