IBM Support

LI74706: DB2 INSTANCE CRASH WHEN THE TABLE DATA PARTITIONED BY SINGLE-BYTE KEY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • The CREATE TABLE statement could lead a DB2 instance to crash
    when running DB2 V9.1:
    
    1. table is partitioned.
    2. table has a varchar column with FOR SBCS DATA
    3. the partitioning column is on the same column as 2.
    
    For non-SBCS fields, CREATE TABLE works correctly.
    

Local fix

  • An instance crash can be avoided by eliminating using of "FOR
    SBCS DATA" clause with character data types.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 crashes when the table data partitioned by single-byte   *
    * key                                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * It is recommended to upgrade to DB2 v9.1 FP9.                *
    ****************************************************************
    

Problem conclusion

  • The code fix has been added to DB2 v9.1 FP 9.
    

Temporary fix

  • As temporary work around, it is recommended do not partition a
    
    
    table by a single-byte key.
    

Comments

APAR Information

  • APAR number

    LI74706

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-06

  • Closed date

    2010-04-20

  • Last modified date

    2010-04-20

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

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

    LI74713 IC61971

Fix information

Applicable component levels

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

Document Information

Modified date:
17 October 2021