IBM Support

IC79773: PAUSING INPLACE TABLE REORG RETURNS SQL2219N RC=11, BUT OLR SHOWS AS IN PROGRESS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When issuing a pause on an inplace table reorg that has nearly
    finished reorganizing the table, DB2 may incorrectly return
    SQL2219N Reason Code 11: "There is no table reorganization to
    PAUSE or STOP". However, monitoring utilities may still show
    that the reorganization is still in progress. This contradiction
    occurs during a timing window where the reorganization has
    completed processing all rows but has not yet committed because
    it is waiting for existing readers and writers on the table to
    complete.
    

Local fix

  • The reorg on the table has completed processing and is waiting
    for
    existing readers and writers to complete. The SQL2219N RC=11
    error message may be safely ignored. The reorg will commit and
    disappear from monitoring when all existing readers and writers
    complete.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * An SQL2219N RC=11 error may be returned stating that there   *
    * is no reorg on the table even though monitoring shows that   *
    * there is a reorg on the table. This reorg has finished       *
    * moving rows, but has not yet fully committed.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fix Pack 6.                              *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in DB2 V9.7 Fix Pack 6. Instead of
    returning SQL2219N RC=11 in this scenario, DB2 will now return
    SQL2219N RC=10, which is a more accurate reflection of the
    correct status of the inplace reorg.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79773

  • 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

    2011-11-13

  • Closed date

    2014-07-04

  • Last modified date

    2014-07-04

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

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

    IC81291

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79773

Modified date: 04 July 2014