|
Problem IC62350
|
Status: Geschlossen |
SET INTEGRITY RETURNS SQL1224 AFTER ONLINE LOAD WITH CONSTRAINTS TO A TABLE WITH ONLY XML INDEXES. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
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. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.08.2009
24.02.2010
24.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.5
|
 |
