Symptom
In a Db2 HADR environment, tablespace reclaim operation (reduce HWM) on the primary database causes the tablespace to go into a RF Pending state (0x00000080) on the Standby database with error SQLB_TBSPACE_TOO_SMALL.
Here is the logging (db2diag.log) reported on the standby database:
2023-10-16-15.05.39.839514+480 I3054450134A750 LEVEL: Error
PID : 29937 TID : 607 PROC : db2sysc 0
INSTANCE: db2sap NODE : 000 DB : SAP
APPHDL : 0-104 APPID: *LOCAL.DB2.231014035727
HOSTNAME: hostname
EDUID : 607 EDUNAME: db2redom (SAP) 0
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 : <preformatted>
useablePages is less than the High Water Mark
or usedPages is greater than the High Water Mark
useablePages = 765766968
HighWaterMark = 559800190
usedPages = 742407324
Table space ID = 12
2023-10-16-15.05.39.840035+480 I3054450885A518 LEVEL: Error
PID : 29937 TID : 607 PROC : db2sysc 0
INSTANCE: db2sap NODE : 000 DB : SAP
APPHDL : 0-104 APPID: *LOCAL.DB2.231014035727
HOSTNAME: hostname
EDUID : 607 EDUNAME: db2redom (ISP) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:95
MESSAGE : ZRC=0x8002013A=-2147352262=SQLB_TBSPACE_TOO_SMALL
"Cannot reduce tablespace size as requested"
2023-10-16-15.05.39.840114+480 E3054451404A887 LEVEL: Error
PID : 29937 TID : 607 PROC : db2sysc 0
INSTANCE: db2sap NODE : 000 DB : SAP
APPHDL : 0-104 APPID: *LOCAL.DB2.231014035727
HOSTNAME: hostname
EDUID : 607 EDUNAME: db2redom (ISP) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:9776
MESSAGE : ADM6083E An error occurred while redoing an alter tablespace
operation against table space "SAP#BTABD" (ID "12") This error will
be temporarily ignored while the remainder of the transaction is
replayed. If the alter operation is eventually rolled back then the
error will be discarded. However, if the operation is committed then
this error will be returned, stopping recovery against the table
space.
2023-10-16-15.05.39.845392+480 E3054452292A589 LEVEL: Error
PID : 29937 TID : 607 PROC : db2sysc 0
INSTANCE: db2sap NODE : 000 DB : SAP
APPHDL : 0-104 APPID: *LOCAL.DB2.231014035727
HOSTNAME: hostname
EDUID : 607 EDUNAME: db2redom (ISP) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbIncPoolState, probe:4756
MESSAGE : ADM12512W Log replay on the HADR standby has stopped on table space
"SAP#BTABD" (ID "12") because it has been put into "ROLLFORWARD
PENDING" state.
Read more...
Environment
- DB2 version 10.5 and 11.1
Product
Keywords
HADR, SQLB_TBSPACE_TOO_SMALL , ROLLFORWARD PENDING , IT29380 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.