|
Problem IC65398
|
Status: Geschlossen |
NO ERROR DURING LOAD WHEN PARTITIONING KEY OF EXCEPTION TABLE DOESN'T MATCH LOAD TABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
A partitioning key on the exception table needs to match the
load table.
If for instance the load table has partitioning key
distribute by hash ( col1, col2, col3 )
and the exception table only has :
distribute by hash ( col1 )
Then db2 will currently allow this, leading to an incorrect
hashing of rows into the exception table. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Load users with partitioned tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* Exception table created by load may return wrong *
* resultsifthe exception table was created with *
* adifferentpartitioning key. *
****************************************************************
* RECOMMENDATION: *
* Partitioning key for the exception table needs to be *
* thesameas the table that is loaded.The fix for this APAR *
* willreturn an error if this is notthe case. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 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
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
This problem was first fixed in V9.5 Fix Pack 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.01.2010
26.04.2010
26.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
