DB2 - Problem description
Problem IT30795 | Status: Closed |
NUMBLOCKPAGES OF A BUFFERPOOL MAY BE ADJUSTED TO AN INVALID VALUE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
STMM tries to shrink the bufferpools by a factor (sqlbScaleAutoBPsByFactor()): FUNCTION: DB2 UDB, buffer pool services, sqlbScaleAutoBPsByFactor, probe:12828 DATA #1 : Defer writing on-disk changes for BP ID=7;old size=156585; new size=57365 In some scenario the bufferpool is shrunk to a negative size leading to the sqlbfix error: FUNCTION: DB2 UDB, buffer pool services, sqlbScaleAutoBPsByFactor, probe:12828 DATA #1 : Defer writing on-disk changes for BP ID=8;old size=156585; new size=57365 FUNCTION: DB2 UDB, buffer pool services, sqlbSetNumSlotsAndNBPForNewRTBPDef, probe:20 MESSAGE : ADM6069W Buffer pool "XXXXXXXX" (ID "8") has a NUMBLOCKPAGES value of "4096" which exceeds the maximum supported value for a buffer pool of this size. The NUMBLOCKPAGES value for this buffer pool has been reduced to "-2147483648" for its current activation. The value of NUMBLOCKPAGES can be permanently changed by using the ALTER BUFFERPOOL SQL statement. FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:1632 DATA #1 : String, 67 bytes sqlbSetNumSlotsAndNBPForNewRTBPDef: max numPages has been exceeded! DATA #2 : Hexdump, 4 bytes 0x00007FCD3AFFA620 : 5486 FEFF T... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.5 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.5 or later * **************************************************************** | |
Comment | |
Upgrade to Db2 11.1.4.5 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.10.2019 31.10.2019 31.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |