DB2 - Problem description
|Problem IC61922||Status: Closed|
"DATABASE PAGE SIZE" = OFF IS RETURNED BY DB2 GET DB CFG
DB2 FOR LUW / DB2FORLUW / 950 - DB2
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.
See Error description field for more information.
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
Problem was first fixed in DB2 UDB Version 9.5 FixPack 5.
not known / see Local fix
forerunner : APAR is sysrouted TO one or more of the following: IC62152 follow-up :
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)|
|Problem solved according to the fixlist(s) of the following version(s)|