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

LOAD MIGHT TRAP AND CRASH THE INSTANCE IN CERTAIN CONDITIONS

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Load MIGHT trap and crash the instance when the following 
conditions exists: 
-- Table includes many columns along with at least a primary key 
or unique index 
-- Load from CURSOR or IXF 
-- METHOD N is specified with a long list of column names 
-- The data loaded contains duplicate records so that the DELETE 
phase is needed 
 
The stack for the trap shows: 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x000000000000F480 ?unknown + 0x0 
0x0900000007B4719C 
sqluvload__FPUcT1P9SQLP_LSN8P7sqlubmhPP15sqlu_media_listT5UcP26s 
qluCLoadRequestDescriptorP8sqluvlcbPi + 0x84 
0x09000000084757B4 
@148@call_sqluvload__FP8sqeAgentP12SQLB_GLOBALSP26sqluCLoadReque 
stDescriptorP20sqlu_loadapi_load_cbiT5PiT7 + 0x764 
0x09000000072DBD3C 
sqluLoadPartition__FP8sqeAgentP26sqluCLoadRequestDescriptoriN23P 
iT6 + 0x4D4 
0x09000000072DB178 
sqlu_register_table_load__FP26sqluCLoadRequestDescriptorP24sqlus 
CLoadMPPCoordinatorP15sql_static_dataPb + 0xF38 
0x09000000084852DC sqluvtld_route_in__FP12SQLE_DB2RA_T + 0xD34 
0x09000000084938EC sqluvtld_route_in__FP12SQLE_DB2RA_T@glue1858 
+ 0x74 
0x0900000006020188 sqlesrvr__FP14db2UCinterface + 0x8EC 
0x0900000006834D94 sqleMappingFnServer__FP5sqldaP5sqlca + 0x358 
0x0900000006834928 
sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5 
sqlca + 0x32C 
0x090000000683A674 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 
0x628 
0x0900000006839E84 
.sqljs_ddm_excsqlstt.fdpr.clone.217__FP14db2UCinterfaceP13sqljDD 
MObject + 0xC8 
0x09000000066DCDDC 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0xF8 
0x09000000066DD164 
.sqljsParse.fdpr.clone.52__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s 
qeAgentb + 0x260 
0x09000000066DBB84 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x2A4 
0x0900000006538A4C 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA4 
0x09000000065387E4 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x264 
0x09000000065382C0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0xE0 
0x090000000659B030 RunEDU__8sqeAgentFv + 0x2FC 
0x090000000659D8FC EDUDriver__9sqzEDUObjFv + 0xD8 
0x09000000065B131C sqloEDUEntry + 0x260 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on DB2 v9.7 Fix Pack 7 and lower                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Fix Pack 8 or higher                              * 
****************************************************************
Local Fix:
N/A
available fix packs:
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 v9.7 Fix Pack 8
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC89203 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.12.2012
23.08.2013
23.08.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.8 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.