|
Problem IC61950
|
Status: Closed |
LOAD RESTART AFTER THE LOAD PHASE WITH COPY YES OPTION ON INTO THE XML TABLE, THE SUBSEQUENT ROLLFORWARD FAILS |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
If the load crashed in the build or delete phase when loading
data into the XML table with COPY YES on. The following load
restart command will not be able to generate the correct copy
file. Therefore the subsequent rollforward command will fail
with SQL1271W in serial mode and SQL1042C in DPF mode. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V95 on all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* If the load crashed in the build or delete phase when *
* loading data into the XML table with COPY YES option on. The *
* following load restart command will not be able to generate *
* the correct copy file. Therefore the subsequent rollforward *
* command will fail with SQL1271W in serial mode and SQL1042C *
* in DPF mode. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V95fp5 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 V95 Fix Pack 5. This fix
should be applied on the server. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC64052
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.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
|
 |
