|
Problem IC84168
|
Status: Closed |
COLUMN DATAPARTITIONEXPRESSION IN SYSCAT.DATAPARTITONEXPRESSION CATALOG VIEW DOESN'T GET UPDATED UPON ALTERING A COLUMN NAME |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 10 fixpak 1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 10, fixpak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
03.12.2012
03.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
