IBM Support

IC91020: LOG FULL DURING REORG INDEX(ES ALL) WITH THE CLEANUP ONLY ALL OPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running REORG INDEX(ES ALL) with the CLEANUP ONLY ALL
    option, DB2 will issue an internal commit after each index is
    cleaned.  However, when dealing with very large indexes on a
    volatile database (i.e. a database that writes a large amount of
    data to the database transaction logs), this may not be frequent
    enough.  If all of the active log space is consumed, then
    applications writing to this database may fail with log full
    error (SQLCODE SQL0964C).
    

Local fix

  • Configure the database to allow more active log files.  For
    example, you can enable infinite active logspace by setting the
    LOGSECOND database configuration parameter to -1.  For more
    information on database logging, see the document titled
    "Configuration parameters for database logging" in the DB2
    Information Center.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 FP9.                                     *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 v9.7 FP9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC91020

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-21

  • Closed date

    2013-12-23

  • Last modified date

    2013-12-23

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

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

    IC91894 IC95277

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R980 PSN

       UP

  • RA10 PSN

       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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 December 2013