IBM Support

IC63760: Table size may unnecessarily increase after failed inserts.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When rows are inserted into a table, if all the free space in
    the existing pages is consumed,
    the table will to into append mode temporarily, until more space
    is available for inserts;
    for example, when subsequent inserts cause a new page to be
    added to the table.
    This can for instance happen on an import.
    
    However, if those subsequent inserts fail, the new page will
    still be allocated to the table but
    the table may remain in append mode.
    This will result in further inserts being appended to the table
    rather than reusing
    the space freed up by the failed inserts.  This can cause the
    table to grow in size
    without new rows being added.
    

Local fix

  • To clear this append state, either restart the database, or
    perform
    a number of successful inserts to ensure the allocation of new
    pages.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Table size may increase unexpectedly after failed inserts    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the database server to V9.7 Fix Pack 3               *
    ****************************************************************
    

Problem conclusion

  • The problem was first fixed in V9.7 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC63760

  • 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

    2009-10-16

  • Closed date

    2010-08-11

  • Last modified date

    2010-08-11

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

    IZ55188

  • 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

  • R970 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:
11 August 2010