| Neueste Versionen | 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 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC65873 | Status: Geschlossen |
LOADING INTO A TABLE WITH AN EXCEPTION TABLE AFTER EXECUTE "ALTER TABLE...ALTER COLUMN" MAY ENCOUNTER SQL3604N RC=2 ERROR | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
The LOAD utility would submit an internal query on SYSIBM.SYSCOLUMNS, however, the referenced columns are updated incorrectly by "ALTER TABLE...ALTER COLUMN" due to APAR IZ67850. Thus, on a double byte code page database (e.g. 970 territory KR), loading into a table with an exception table after running "ALTER TABLE...ALTER COLUMN" may result SQL3604N Exception table "TEST_EXCP" corresponding to table "TEST" in the SET INTEGRITY statement or LOAD utility does not have the proper structure, has been defined with unique indexes, constraints, generated columns, or triggers, or is in the Set Integrity Pending state, or is of invalid type. Reason code "2". | |
| Problem-Zusammenfassung: | |
Close | |
| Local-Fix: | |
| 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 |
|