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 IC71734 Status: Closed

IN RARE TIMING SCENARIOS, CLI-LOAD IN DPF MAY CAUSE TRAP WITH INFINITE
RECURSION SYMPTOM.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When a CLI-Load is invoked in a DPF environment, in rare timing 
scenarios a trap is possible. 
 
The symptom will show either a 'db2lpart' or 'db2lmr' EDU with 
infinite recursion in it's StackTrace with repeated entries from 
 
sqluCSerializableSocketTagged::iNext() and 
sqluCSerializableSocketTagged::iOpen(), like so: 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x090000000C790640 iOpen__29sqluCSerializableSocketTaggedFiUiT1 
+ 0x44 
0x090000000C790498 iNext__29sqluCSerializableSocketTaggedFiT1 + 
0x544 
0x090000000C790A40 iOpen__29sqluCSerializableSocketTaggedFiUiT1 
+ 0x444 
0x090000000C78DC64 iNext__23sqluCSerializableSocketFiT1 + 0x130 
0x090000000C790498 iNext__29sqluCSerializableSocketTaggedFiT1 + 
0x544 
........... <thousands of entries like this> ............. 
0x090000000C78DC64 iNext__23sqluCSerializableSocketFiT1 + 0x130 
0x090000000C790498 iNext__29sqluCSerializableSocketTaggedFiT1 + 
0x544 
0x090000000C790A40 iOpen__29sqluCSerializableSocketTaggedFiUiT1 
+ 0x444 
0x090000000C78DC64 iNext__23sqluCSerializableSocketFiT1 + 0x130 
0x090000000C790498 iNext__29sqluCSerializableSocketTaggedFiT1 + 
0x544 
0x090000000C790798 iOpen__29sqluCSerializableSocketTaggedFiUiT1 
+ 0x19C 
 
NOTE: The term "CLI-Load" refers to a CLI application that 
invokes INSERT with the SQL_ATTR_USE_LOAD_API functionality, not 
a CLI application that invokes the db2Load APIs to process a 
data file.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users with CLI-Load in DPF (rare timing scenarios).          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Without this APAR, customer is exposed to the issue as       * 
* described in the "ERROR DESCRIPTION" section.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpack 4.                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 9.7, Fixpack 4.
Workaround
n/a
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC79748 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
06.10.2010
05.05.2011
05.05.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.4 FixList