DB2 FOR LUW / DB2FORLUW / A10 - DB2

The column DATAPARTITIONEXPRESSION in 
SYSCAT.DATAPARTITIONEXPRESSION catalog view doesn't get updated 
upon altering a column name. 
 
Example: 
 
CREATE TABLE R1.RENAMEPARTCOLUMN ("COL1" INTEGER)PARTITION BY 
RANGE ("COL1" NULLS LAST)(PARTITION 0 STARTING(0) INCLUSIVE 
ENDING (50) EXCLUSIVE) 
DB20000I  The SQL command completed successfully. 
 
ALTER TABLE R1.RENAMEPARTCOLUMN RENAME COLUMN COL1 TO COL2 
DB20000I  The SQL command completed successfully. 
 
SELECT TABNAME ,DATAPARTITIONEXPRESSION FROM 
SYSCAT.DATAPARTITIONEXPRESSION WHERE TABNAME = 
'RENAMEPARTCOLUMN' and TABSCHEMA = 'R1' 
TABNAME                     DATAPARTITIONEXPRESSION 
--------------------          --------------------------------- 
RENAMEPARTCOLUMN   COL1  <----------------------- Should be COL2 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10 fixpak 1                           * 
****************************************************************

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10, fixpak 1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.06.2012
03.12.2012
03.12.2012