DB2 FOR LUW / DB2FORLUW / 970 - DB2

When a table has a column with any one of the following 
definitions, 
 
db2 "create table t2 (in int not null with default 0 compress 
system default, in1 int ) value compression" 
db2 "create table t3 (in int not null compress system default, 
in1 int) value compression" 
db2 "create table t5 (ch char not null with default ' ' compress 
system default, in int) value compression" 
 
the DEFAULT will be dumped by /DDEL when the column is not null 
with compress system default, but the default value or data 
itself inside column is 0 or empty char. Ideally, db2d2dart 
/DDEL should output either 0 or empty string depending on the 
data type.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2DART /DDEL EXTRACTS DATA WITH DEFAULT KEYWORD INSTEAD OF  * 
* THE                                                          * 
* DEFAULT VALUE.                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.7 FP4                                           * 
****************************************************************

Manually update the db2dart /DDEL output file.

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 8 for Linux, UNIX, and Windows
 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
 

DB2DART /DDEL EXTRACTS DATA WITH DEFAULT KEYWORD INSTEAD OF THE 
DEFAULT VALUE.

Manually update the db2dart /DDEL output file.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC69382 IC69383 IC69384 
Nachfolger : 

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

03.06.2010
09.05.2011
09.05.2011

9.7.FP4