Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.