DB2 - Problem description
Problem IT37374 | Status: Closed |
REDO OF FREEEXTS LOG RECORD CAN CORRUPT HWM OF TALBESPACE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
The problem can occur with redo of FreeExts where HWM can be set less than used page of tablespace which later encounters a failure of extent movement. Following db2diag.log message indicates the problem has occurred: 2019-11-24-15.34.47.520984-360 I2494613A777 LEVEL: Error PID : 24117820 TID : 85584 PROC : db2sysc 4 INSTANCE: NODE : 004 DB : APPHDL : 0-8339 APPID: AUTHID : HOSTNAME: EDUID : 85584 EDUNAME: db2redom (BP1) 4 FUNCTION: DB2 UDB, buffer pool services, sqlbValidateContOpsMain, probe:150 MESSAGE : ZRC=0x8002013A=-2147352262=SQLB_TBSPACE_TOO_SMALL "Cannot reduce tablespace size as requested" DATA #1 : useablePages is less than the High Water Mark or usedPages is greater than the High Water Mark useablePages = 5082368 HighWaterMark = 3598736 usedPages = 4261312 Table space ID = 657 2019-11-24-15.34.47.533060-360 I2495391A550 LEVEL: Error PID : 24117820 TID : 85584 PROC : db2sysc 4 INSTANCE: NODE : 004 DB : APPHDL : 0-8339 APPID: AUTHID : HOSTNAME: EDUID : 85584 EDUNAME: db2redom (BP1) 4 FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:95 MESSAGE : ZRC=0x8002013A=-2147352262=SQLB_TBSPACE_TOO_SMALL "Cannot reduce tablespace size as requested" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * update to Db2 11.5m4fp0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * update to Db2 11.5m4fp0 or higher * **************************************************************** | |
Comment | |
First fixed in Db2 Version 11.5m4fp0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.06.2021 22.06.2021 22.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |