|
Problem IC61826
|
Status: Closed |
On 32bit platforms, LOAD returns SQL0668N WHEN THE TARGET TABLE HAS the XML COLUMNwhich is part of the index key of an index. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| 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 DB2 server. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.07.2009
18.02.2010
18.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
|
 |
