DB2 FOR LUW / DB2FORLUW / 970 - DB2

The CREATE TABLE statement could lead a DB2 instance to crash 
when running DB2 V9.7: 
 
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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The sequence below fails on CREATE TABLE. Without "FOR       * 
* SBCSDATA" clause statement goes                              * 
* correct.------------------------------------------------------ 
* DATABASE prova USING CODESET iso885915 TERRITORY it;CONNECT  * 
* TO prova;CREATE TABLESPACE TS1 MANAGED BY SYSTEM USING       * 
* ('/xxx/TS1');CREATE TABLE zzz (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.7 FP2                                      * 
****************************************************************

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

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem has been fixed for DB2 v9.7 FP2

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.07.2009
25.05.2010
25.05.2010

9.7.FP2