IBM Support

IT24004: DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The db2acd might choose index rebuild when reorg is necessary
    for an index. When no offline window is setup e.g. in the auto
    maintenance policies the reorg might fail with:
    
    SQL22022N  The duration of the maintenance window is not long
    enough to run the maintenance activity.
    
    Due to this, the index will not be reorganized and might take
    more space and might have a higher number of levels than
    necessary.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fixpack 3 higher                   *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24004

  • 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

    2018-02-09

  • Closed date

    2018-08-07

  • Last modified date

    2018-08-27

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

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

    IT24115

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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:
27 August 2018