IC91894: 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 users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 10.1.0.3.                             *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 version 10.1.0.3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC91894

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-25

  • Closed date

    2013-10-01

  • Last modified date

    2013-10-01

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

    IC91020

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC91894

Modified date:

2013-10-01

Translate my page

Machine Translation

Content navigation