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

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 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 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