IC65398: NO ERROR DURING LOAD WHEN PARTITIONING KEY OF EXCEPTION TABLE DOESN'T MATCH LOAD TABLE

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

APAR status

• Closed as program error.

Error description

• 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.
  

Local fix

Problem summary

• ****************************************************************
  * 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.                  *
  ****************************************************************
  

Problem conclusion

• This problem was first fixed in V9.5 Fix Pack 6
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC65349

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R950 PSN

     UP