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