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

LOAD: RECORDS REJECTED DURING PARTITIONING ARE NOT COUNTED TOWARDS
WARNINGCOUNT

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When loading data into a table in a DPF environment, i.e. a DPF 
Load, records rejected during partitioning are not counted 
towards the WARNINGCOUNT parameter, so that the load could 
succeed despite some records have been rejected. 
 
Example: 
$ db2 LOAD FROM in.del of DEL WARNINGCOUNT 1 MESSAGES msg.out 
REPLACE INTO dummy PARTITIONED DB CONFIG PARTITIONING_DBPARTNUMS 
\(0,1\) 
 
  Agent Type     Node     SQL Code     Result 
________________________________________________________________ 
______________ 
  LOAD           000      +00000000    Success. 
________________________________________________________________ 
______________ 
  LOAD           001      +00000000    Success. 
________________________________________________________________ 
______________ 
  PARTITION      000      +00000000    Success. 
________________________________________________________________ 
______________ 
  PARTITION      001      +00003107    Success. 
________________________________________________________________ 
______________ 
  PRE_PARTITION  000      +00000000    Success. 
________________________________________________________________ 
______________ 
  RESULTS:       2 of 2 LOADs completed successfully. 
________________________________________________________________ 
______________ 
 
Summary of Partitioning Agents: 
Rows Read                   = 12 
Rows Rejected               = 1 
Rows Partitioned            = 11 
 
Summary of LOAD Agents: 
Number of rows read         = 11 
Number of rows skipped      = 0 
Number of rows loaded       = 11 
Number of rows rejected     = 0 
Number of rows deleted      = 0 
Number of rows committed    = 11 
 
SQL3107W  At least one warning message was encountered during 
LOAD processing.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Problem was first fixed in DB2 Version 10.5 and Fix Pack 3   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in DB2 Version 10.5 and Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2013
27.02.2014
27.02.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList