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

A QUERY CRASHED DB2 DUE TO THE BAD SECTION WITH DUPLICATE RELOC ENTRIES

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
A query crashed db2 with the following stack info: 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x090000003C59A144 sqlritt2__FP8sqlrr_cb + 0xCC 
0x090000003D1E9248 
.@161@sqliScanLeaf2.fdpr.clone.5408__FP7SQLI_CBP11SQLI_SFGLOB + 
0x28C 
0x090000003D1EAF10 
.sqlifnxt.fdpr.clone.5390__FP7SQLI_CBP11SQLI_SFGLOB + 0x3C8 
0x090000003D1E715C 
.sqlirdk.fdpr.clone.3700__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP 
8SQLD_KEYP12SQLI_KEYDATAP9sqli_scanPi + 0xA60 
0x090000003D1E609C 
.sqldIndexFetch.fdpr.clone.232__FP8SQLD_CCBP8SQLZ_RID + 0x69C 
0x090000003D1E5210 
sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT 
3P12SQLD_ID_LISTP9SQLP_LSN8 + 0xD98 
0x090000003D1CA81C sqlritaSimplePerm__FP8sqlrr_cb + 0x4A0 
0x090000003D1E2194 sqlrievl__FP8sqlrr_cb + 0x24 
0x090000003D1E01C8 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 
0x34 
0x090000003D1058EC 
sqlrr_process_fetch_request__FP14db2UCinterface + 0xF08 
0x090000003D1038C4 
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x12E8 
0x090000003D1016EC 
sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x1D70 
0x090000003D1448B8 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x1AC 
0x090000003D144534 
.sqljsParse.fdpr.clone.230__FP13sqljsDrdaAsCbP14db2UCinterfaceP8 
sqeAgentb + 0x56C 
0x090000003D13F68C @73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x27C 
0x090000003CB31924 
@73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 
0x090000003CB3237C 
@73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x558 
0x090000003CB315F0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x21C 
0x090000003CE5B0FC RunEDU__8sqeAgentFv + 0x584 
0x090000003CE57454 EDUDriver__9sqzEDUObjFv + 0x13C 
0x090000003CE572DC sqlzRunEDU__FPcUi + 0x10 
0x090000003CE64248 sqloEDUEntry + 0x264 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* User who use db2 v10.1                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 v10.1 fp5 or above                            * 
****************************************************************
Local Fix:
Rewrite the query may avoid the crash
Solution
The problem is first fixed in db2 v10.1 fp5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.04.2014
15.07.2015
15.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList