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 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 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.