SAP Knowledge Base Article - Preview

3422000 - Reclaim operation (reduce HWM) reports SQLB_TBSPACE_TOO_SMALL and RF Pending on Standby database.

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

SAP ERP 6.0

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.