IBM Support

JR25637: SOLUTION TO DETECT PACKED DESCRIPTOR CORRUPTION (CAUSED BY APAR LI70946) AND CORRECT IT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Fix for APAR LI70946 ( ALTER TABLE STATEMENTS MAY RESULT IN
    TABLE PACKED DESCRIPTOR CORRUPTION), does not cater for
    corruption already existing on the system.
    Its workaround is to Run RUNSTATS on the tables on which the
    Alter command has been run previously to the fix.
    
    Access to a table with corrupted packed descriptor might casue
    the DB2 database to crash.
    
    There is a need to detect the corruption early and prevent traps
    occurring due to an ALTER statement problem.
    

Local fix

  • Run RUNSTATS on tables with corrupted Packed Descriptor
    

Problem summary

  • PROBLEM SUMMARY
    Users Affected: All
    Problem description:SOLUTION TO DETECT PACKED DESCRIPTOR
    CORRUPTION (CAUSED BY APAR
    LI70946) AND CORRECT IT
    
    Problem Summary:
    The Fix for APAR LI70946 ( ALTER TABLE STATEMENTS MAY RESULT IN
    TABLE PACKED DESCRIPTOR CORRUPTION), does not cater for
    corruption already existing on the system.
    Its workaround is to Run RUNSTATS on the tables on which the
    Alter command has been run previously to the fix.
    
    Access to a table with corrupted packed descriptor might casue
    the DB2 database to crash.
    
    There is a need to detect the corruption early and prevent traps
    occurring due to an ALTER statement problem.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 3, s070719
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR25637

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-12-29

  • Closed date

    2007-09-12

  • Last modified date

    2009-02-23

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

    IY93161

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

Fix information

  • Fixed component name

    DB2 CEE WINDOWS

  • Fixed component ID

    5765F3001

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

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

Document Information

Modified date:
07 January 2022