DB2 - Problembeschreibung
Problem IC65874 | Status: Geschlossen |
ALTER TABLE...ALTER COLUMN" MAY CAUSE SYSIBM.SYSCOLUMNS COLUMNS BECOME OUT OF SYNC | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
Close | |
Local-Fix: | |
Always use the catalog view SYSCAT.COLUMNS and refer to the column CODEPAGE for the compatible code page. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Close | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.01.2010 30.06.2010 30.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |