IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    LI73612

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-18

  • Closed date

    2008-11-03

  • Last modified date

    2010-02-05

  • 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

[{"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:
15 October 2021