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