| 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 IC65873 | Status: Closed |
LOADING INTO A TABLE WITH AN EXCEPTION TABLE AFTER EXECUTE "ALTER TABLE...ALTER COLUMN" MAY ENCOUNTER SQL3604N RC=2 ERROR | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
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 Summary: | |
Close | |
| Local Fix: | |
| 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 |
|