home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 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

DB2 - Problem description

Problem IC97332 Status: Closed

LOAD FROM REMOTE CURSOR (REMOTE FETCH LOAD) MAY HANG AFTER GETTING AN ERROR
IN VERY EARLY PHASE

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
When doing LOAD from remote cursor (also known as "remote fetch" 
load), db2lueff process is spawned.  If the LOAD gets an error, 
db2lueff is killed by the main load agent. However, if the error 
occurs in very early phase, db2lueff may not be started at that 
time. In this case the application performing the LOAD will hang 
and cannot be forced. 
 
This can only occur in single-node (i.e. non-DPF) systems. 
 
Any errors that cause LOAD error very early, can potentially hit 
this timing hole issue.  If a LOAD fails in BUILD phase or 
DELETE phase, this problem cannot occur.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using LOAD from remote cursor.                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 4.                      * 
****************************************************************
Local Fix:
Not issuing LOAD from remote cursor.
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 10.1 Fix Pack 4.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC98890 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
31.10.2013
07.07.2014
07.07.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.4 FixList