DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 and Fix Pack 6                    * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix pack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84168 
Nachfolger : 

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

07.11.2011
15.04.2013
15.04.2013

9.7.,
9.7.FP6