DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 instance crashes on LOAD execution due to invalid check 
involving non-nullable columns. The issue might occur when the 
following conditions are met: 
 
-- Fewer columns are loaded than are in the table. 
-- At lease one column is defined with explicit default value. 
-- In omitted columns, at least one column is not null with 
compress system default. 
 
The crash will result in a trap file with the following stack: 
 
gsignal 
abort 
sqloExitEDU 
sqle_panicv 
sqlulGetDefaultInput 
sqluSetupValuesArray 
sqluFormatterSetup 
sqluCFormatter 
sqluLoadEDUDriver 
sqloEDUEntry 
... 
clone 
 
The issue can be reproduced as follows: 
 
db2 "create table t1 (c1 int, c2 int not null compress system 
default, c3 int not null with default 0)" 
db2 "load from /dev/null of del replace into t1(c1)"

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP9                                      * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in DB2 v9.7 FP9

keiner bekannt / siehe Local-Fix

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

25.06.2013
17.12.2013
17.12.2013

9.7.FP9