Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC61922 Status: Closed

"DATABASE PAGE SIZE" = OFF IS RETURNED BY DB2 GET DB CFG

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
If you follow below steps on DB2 UDB V9.5 FP4: 
db2 drop db test 
db2 create db test 
db2 connect to test 
db2 get db cfg for test 
it will return as shown below: 
------------- 
       Database Configuration for Database test 
 Database configuration release level             = 0x0c00 
 Database release level                           = 0x0c00 
 Database territory                               = US 
 Database code page                               = 1208 
 Database code set                                = UTF-8 
 Database country/region code                     = 1 
 Database collating sequence                      = SYSTEM_819 
 Alternate collating sequence       (ALT_COLLATE) = 
 Number compatibility                             = OFF 
 Varchar2 compatibility                           = OFF 
 Database page size                               = OFF 
    <snip> 
------------- 
As we can see, "Database page size" is returned as OFF 
unexpectedly. This is just a display issue from CLP. 
This problem does not exist on V9.5 FP3, V9.5 FP3a and V9.5 
FP3b.
Problem Summary:
See Error description field for more information.
Local Fix:
Use db2parm db <dbname> g pagesize to see db cfg parameters 
instead of db2 get db cfg command.
available fix packs:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 9.5 FixPack 5.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC62152 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.07.2009
04.01.2010
04.01.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.5 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.