home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC69384 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* 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.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Manually update the db2dart /DDEL output file.               * 
****************************************************************
Local-Fix:
Manually update the db2dart /DDEL output file.
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.06.2010
22.03.2011
22.03.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version