DB2 - Problem description
Problem IT39517 | Status: Closed |
THE DB2PD FUNCTION GETS VALUE FOR CF_GBP_SZ FROM THE DB CONFIG STRUCTURE IN MEMORY WHICH IS INCORRECT. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When CF_GBP_SZ is updating the value provided by DBA in the command is different than created memory structure. For the CF_GBP_SZ, CF maintains its own structure of this parameter. That is apart from the db config. It gets the CF_GBP_SZ in 256 byte increments. So when you set it to a number divisible by 256, everything lines up properly. It lead to the situation that there are a difference between results of "get db cfg" and "db2pd -dbcfg" It was checked that get db cfg is returning the correct value (the size which was really created), but db2pd return value stored in cfg. Expected behavior is db2pd also get the memory value from the CF instead of the in memory db cfg structure. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users which are using PURESCALE solution * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Official Special builds for versions 11.5.6 and 11.5.7 were * * available. * * * * As a workaround "get db cfg" command should be used to check * * the current value of CF_GBP_SZ. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All users which are using PURESCALE solution * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Official Special builds for versions 11.5.6 and 11.5.7 were * * available. * * * * As a workaround "get db cfg" command should be used to check * * the current value of CF_GBP_SZ. * **************************************************************** | |
Comment | |
For the CF_GBP_SZ, CF maintains its own structure of this parameter. That is apart from the db config. It gets the CF_GBP_SZ in 256 byte increments. So when you set it to a number divisible by 256, everything lines up properly. The "get db cfg" command will actually ask the CF structure instead of looking at the db config structure which is the correct behavior. The db2pd function gets it from the db config structure in memory which is incorrect. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.12.2021 08.07.2022 08.09.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |