|
Problem IC62350
|
Status: Closed |
SET INTEGRITY RETURNS SQL1224 AFTER ONLINE LOAD WITH CONSTRAINTS TO A TABLE WITH ONLY XML INDEXES. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
Load data with ALLOW READ ACCESS option on into an XML table
with only XML indexes. If the table has some constraints, the
subsequent SET INTEGRITY will fail with the error code SQL1224. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Load data with ALLOW READ ACCESS option on into an XML table *
* *
* with only XML indexes. If the table has some constraints, *
* the *
* subsequent SET INTEGRITY will fail with the error code *
* SQL1224. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V95fp5 or later. *
**************************************************************** |
| Local Fix: |
This problem only occurs when there are only XML indexes created
on the table. As a workaround, one or more relational indexes
can be created for this table. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.5 Fix Pack 5. This fix
should be applied on the server. |
| Workaround |
This problem only occurs when there are only XML indexes created
on the table. As a workaround, one or more relational indexes
can be created for this table. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.08.2009
24.02.2010
24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.5
|
 |
