|
Problem IC61826
|
Status: Geschlossen |
On 32bit platforms, LOAD returns SQL0668N WHEN THE TARGET TABLE HAS the XML COLUMNwhich is part of the index key of an index. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
This problem happens in the following scenario on 32bit
platforms:
1. Run a load operation that loads data into the target table
that has the XML column which is part of the index key of an
index on the target table. This load operation is
interrupted by the SIGINT signal.
2. Run a load terminate command to terminate the previous
interrupted load operation.
3. Run the load operation in step 1 again, the SQL message
SQL0668N will be returned with the reason code 5. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Occurs on all 32bit platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* If this APAR is not applied, This problem would happen in *
* the following scenario on 32bit *
* platforms: *
* *
* 1. Run a load operation that loads data into the target *
* table *
* that has the XML column which is part of the index key of an *
* *
* index on the target table. This load operation is *
* interrupted by the SIGINT signal. *
* 2. Run a load terminate command to terminate the previous *
* *
* interrupted load operation. *
* 3. Run the load operation in step 1 again, the SQL message *
* *
* SQL0668N will be returned with the reason code 5. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 Fix Pack 5 or later. *
**************************************************************** |
| Local-Fix: |
|
| 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 DB2 server. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.07.2009
18.02.2010
18.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.5
|
 |
