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

DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 2a - interim special build 2a
DB2 Version 9.1 Fix Pack 1   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 2   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

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

• Users Affected:      Users altering column defaults via ALTER
                       TABLE.
  Problem Description: The alter may cause corruption to the
                       statistics for the table and can be
                       rectified by running runstats.
  Problem Summary:     ALTER TABLE STATEMENTS MAY RESULT IN TABLE
                       PACKED DESCRIPTOR CORRUPTION.
  

Problem conclusion

• First fixed in DB2 UDB Version 9 fixpack 1.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  DB2 CUE LINUX

• Fixed component ID

  5724B6204

Applicable component levels

• R910 PSY

     UP