|
Problem IC79656
|
Status: Closed |
COLUMN DATAPARTITIONEXPRESSION IN SYSCAT.DATAPARTITONEXPRESSION CATALOG VIEW DOESN'T GET UPDATED UPON ALTERING A COLUMN NAME |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 and Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.7 Fix pack 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84168
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.11.2011
15.04.2013
15.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
