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 IT09394 Status: Geschlossen

INGEST: SQL0804N OR INCORRECT DECIMAL DATA LOADED WHEN DECIMAL IS IN ASCII
AND PRECISIONS DO NOT MATCH

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
A problem in injest logic could result in random SQL0804N 
messages or incorrect decimal data being loaded. 
The problem can occur only when both of the following are true: 
- The decimal number is represented in ASCII in the input file 
or pipe. 
- That ASCII representation excluding leading zeros has a 
precision less than the default precision or less than the 
precision specified on the field definition (if any). 
For example: 
000000000064913.   precision excluding leading zeros is 5 
100000000064913.   precision excluding leading zeros is 15 
The precision of a decimal field can be determined as follows: 
- If the INGEST command omits the field definition list, then 
the precision is the same as the precision of the corresponding 
table column. 
- If the INGEST command specifies a field definition list but 
the precision of a decimal field is not specified, the precision 
defaults to 5. 
- Otherwise, the precision is whatever is specified on the field 
definition. 
The problem is more likely when ingesting input files that are 
about 400 MB in size or larger.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install This fix                                             * 
**************************************************************** 
RECOMMENDATION: Upgrade to v105. Fixpak 7
Local-Fix:
Ensure that the number of digits in decimal values in the input 
file or pipe is always the same as the precision specified on 
the field definition  or  the same as  default precision if the 
field definition or precision are omitted.
Lösung
Problem was first fixed in DB2 UDB version 10.5 Fixpak 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.06.2015
19.01.2016
05.03.2017
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList