IBM Support

LI70946: ALTER TABLE STATEMENTS CAN RESULT IN TABLE PACKED DESCRIPTOR CORRUPTION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Issuing a RUNSTATS WITH DISTRIBUTION statement against a table,
    followed by an ALTER TABLE ALTER COLUMN SET DEFAULT statement
    can cause a table to contain corrupt packed descriptor
    information.
    
    The corruption relates to column distribution statistics and can
    be rectified by issuing the RUNSTATS WITH DISTRIBUTION statement
    again.
    
    Accessing the table might result in traps, or modified access
    plans which can lead to performance degradation.
    

Local fix

  • Please contact DB2 support to confirm if tables have been
    affected specifically by this issue.  Once confirmed, re-running
    RUNSTATs on the table after running the ALTER command(s) should
    fix the corruption.
    

Problem summary

  • Problem Summary:
    ALTER TABLE STATEMENTS MAY RESULT IN TABLE PACKED DESCRIPTOR
    CORRUPTION.
    Problem Description:
    When issuing the ALTER TABLE ALTER COLUMN SET DEFAULT statement
    corruption may be introduced to the statistics portion
    of table's packed descriptor.
    Users Affected:
    Any issuing the ALTER TABLE ALTER COLUMN SET DEFAULT statement.
    

Problem conclusion

  • First fixed in DB2 UDB Version 8.1, FixPak 13
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI70946

  • Reported component name

    DB2 CUE LINUX

  • Reported component ID

    5724B6204

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Serviceability

  • Submitted date

    2006-07-07

  • Closed date

    2006-09-27

  • Last modified date

    2007-02-17

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

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

    LI71014 LI71015

Fix information

  • Fixed component name

    DB2 CUE LINUX

  • Fixed component ID

    5724B6204

Applicable component levels

  • R820 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 October 2021