IBM Support

IT32973: REDO OF FREEEXTS LOG RECORD CAN CORRUPT HWM OF TALBESPACE

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

  • 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 : <preformatted>
    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"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * al                                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32973

  • 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

    2020-05-26

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

    IT37374

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
23 June 2021