IBM Support

IT29380: ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Rollforwarding through a FREE_PENDDEL log record may incorrectly
    calculate a table space?s high water mark (HWM) and a subsequent
    ALTER_POOL log record may fail with the following error in
    db2diag.log:
    
    2019-06-07-16.10.49.183375-240 I452476E791           LEVEL:
    Error
    PID     : 28077                TID : 140059818845952 KTID :
    29441
    PROC    : db2sysc
    INSTANCE: XXXXXXXX             NODE : 000            DB   :
    XXXXXXXX
    APPHDL  : 0-15                 APPID: XXXXXXXX
    AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
    EDUID   : 413                  EDUNAME: db2redom (XXXXXXXX)
    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   = 32000
    HighWaterMark  = 6
    usedPages      = 16006
    Table space ID = 3
    
    The HWM is calculated using the wrong SMP page and the resulting
    HWM may be less than useablePages and usedPages. The rollforward
    will fail with:
    
    SQL1271W  Database "<dbname>" is recovered but one or more table
    spaces are
    offline on members or nodes "<nodes>".
    
    The table space will be put in the ROLLFORWARD_PENDING state.
    
    LOCAL FIX:
    None.
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or later                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29380

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-06-10

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT30789

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB50 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 October 2019