|
Problem IC69382
|
Status: Closed |
DB2DART /DDEL EXTRACTS DATA WITH DEFAULT KEYWORD INSTEAD OF THE DEFAULT VALUE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2DART /DDEL EXTRACTS DATA WITH DEFAULT KEYWORD INSTEAD OF *
* THE *
* DEFAULT VALUE. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 9.1 FP10 *
**************************************************************** |
| Local Fix: |
Manually update the db2dart /DDEL output file. |
| available fix packs: |
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
|
| Solution |
DB2DART /DDEL EXTRACTS DATA WITH DEFAULT KEYWORD INSTEAD OF THE
DEFAULT VALUE. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.06.2010
16.06.2011
16.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
