LI73612: SQL0901N RC="PACKED DESCRIPTOR CORRUPTION FOUND.PLEASE RUN RUNSTATS ON... " when Parent globle table name >18 characters

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   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

• Detaching a table partitions with the name of greater
  than 18 characters(parent globle table), after the detach, when
  you try to select from it, you will experience the following
  error:
  .
  ALTER TABLE dwh.FACT_HCAC_HOURLY_CALL_ATTEMPT_COUNTERS_TP DETACH
  PART  HCAC200709  INTO  DWH.DETACHED_HCAC_PART_TP_TEST_20080714A
  SQL3601W  The statement caused one or more tables to
  automatically be placed
  in the Set Integrity Pending state.  SQLSTATE=01586
  .
  select * from DWH.DETACHED_HCAC_PART_TP_TEST_20080714A
  SQL0901N  The SQL statement failed because of a non-severe
  system error.
  Subsequent SQL statements can be processed.  (Reason "Packed
  descriptor
  corruption found. Please run RUNSTATS on this table".)
  SQLSTATE=58004
  .
  As per the message, when trying to run runstats on it,
  it causes the instance to panic and crash:
  .
  RUNSTATS ON TABLE DWH.DETACHED_HCAC_PART_TP_TEST_20080714A ON
  ALL COLUMNS
  .
  SQL2310N  The utility could not generate statistics.  Error
  "-1224" was
  returned.
  .
  Basically, this is a buffer overflow issue and it corrupts
  the packed descriptor for the table in the system catalogs
  when the name of the partitioned table is greater than
  18 characters.
  

Local fix

• Change the parent global table names to less than 18 characters.
  The parent table name should be < 18 BEFORE doing
  any of the detach statements in order to not hit this problem
  

Problem summary

• Detaching a table partitions with the name of greater
  than 18 characters, after the detach, when you try to
  select from it, you will experience the following
  error:
  .
  ALTER TABLE dwh.FACT_HCAC_HOURLY_CALL_ATTEMPT_COUNTERS_TP DETACH
  PART  HCAC200709  INTO  DWH.DETACHED_HCAC_PART_TP_TEST_20080714A
  SQL3601W  The statement caused one or more tables to
  automatically be placed
  in the Set Integrity Pending state.  SQLSTATE=01586
  .
  select * from DWH.DETACHED_HCAC_PART_TP_TEST_20080714A
  SQL0901N  The SQL statement failed because of a non-severe
  system error.
  Subsequent SQL statements can be processed.  (Reason "Packed
  descriptor
  corruption found. Please run RUNSTATS on this table".)
  SQLSTATE=58004
  .
  As per the message, when trying to run runstats on it,
  it causes the instance to panic and crash:
  .
  RUNSTATS ON TABLE DWH.DETACHED_HCAC_PART_TP_TEST_20080714A ON
  ALL COLUMNS
  .
  SQL2310N  The utility could not generate statistics.  Error
  "-1224" was
  returned.
  .
  Basically, this is a buffer overflow issue and it corrupts
  the packed descriptor for the table in the system catalogs
  when the name of the partitioned table is greater than
  18 characters.
  

Problem conclusion

• CSD >= v91 fixpack 6
  

Temporary fix

• Use names less than or equal to 18 characters for the table
  

Comments

APAR Information

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

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

  LI73613

Modules/Macros

• ENGN_SQR
  

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSN

     UP