|
Problem IC65399
|
Status: Geschlossen |
NO ERROR DURING LOAD WHEN PARTITIONING KEY OF EXCEPTION TABLE DOESN'T MATCH LOAD TABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 results *
* ifthe exception table was created with a *
* differentpartitioning key. *
****************************************************************
* RECOMMENDATION: *
* Partitioning key for the exception table needs to be thesame *
* as the table that is loaded.The fix for this APAR will *
* return 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.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
This problem was first fixed in V9.7 Fix Pack 2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.01.2010
22.04.2010
22.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
| 9.7.0.2
|
|
