IBM Support

LI74713: 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 program error.

Error description

  • The CREATE TABLE statement could lead a DB2 instance to crash
    when running DB2 V9.5:
    
    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:                                         *
    * The CREATE TABLE statement below could lead a DB2            *
    * instancetocrash when running DB2 V9.5:CREATE DATABASE <db>   *
    * USING CODESET iso885915 TERRITORY it;CONNECT TO <db>;CREATE  *
    * TABLESPACE TS1 MANAGED BY SYSTEM USING ('/xxx/TS1');CREATE   *
    * TABLE <table> (ID VARCHAR FOR SBCS DATA NOT NULL)PARTITION   *
    * BY (ID)(PART P0 STARTING(MINVALUE) IN TS1,PART P1            *
    * STARTING('A ') ENDING('Z ') IN TS1);                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.5 FP6                                      *
    ****************************************************************
    

Problem conclusion

  • Problem has been fixed for DB2 9.5 FP6
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    LI74713

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-13

  • Closed date

    2010-05-25

  • Last modified date

    2010-05-25

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

    LI74706

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 May 2010