DB2 - Problem description
Problem IT02861 | Status: Closed |
ADMIN_MOVE_TABLE FAILS WITH XML COLUMNS | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Running ADMIN_MOVE_TABLE on a table which contains a XML column fails with the error message: SQL1191N Column "XML" specified in the METHOD parameter does not exist. where "XML" is the name of the XML column. This fails with DB2 9.7 FP9 but works with 9.7 FP8. ADMIN_MOVE_TABLE Trace shows that the column name "XML" is getting replaced with '<a/>'. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 user * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW 9.7 Fix Pack 10 * **************************************************************** | |
Local Fix: | |
Solution | |
Fixed in DB2 LUW 9.7 Fix Pack 10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.06.2014 10.11.2014 10.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |