| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC65874 | Status: Closed |
ALTER TABLE...ALTER COLUMN" MAY CAUSE SYSIBM.SYSCOLUMNS COLUMNS BECOME OUT OF SYNC | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
The catalog table SYSIBM.SYSCOLUMNS contains three codepage-related columns, CODEPAGE, DBCSCODEPG and COMPOSITE_CODEPAGE, each representing the singly byte code page, double byte code page and mixed code page, respectively. During the processing of ALTER TABLE..ALTER COLUMN, we may update the value of CODEPAGE incorrectly and we don't update the value of DBCSCODEPG. The two columns, CODEPAGE and DBCSCODEPG, are mainly used for down level compatibility. | |
| Problem Summary: | |
Close | |
| Local Fix: | |
Always use the catalog view SYSCAT.COLUMNS and refer to the column CODEPAGE for the compatible code page. | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
| Solution | |
Close | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.01.2010 30.06.2010 30.06.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.2 |
|