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

DB2 CRASH AT SQLNGMEMBLOCKLOOKUP

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The trap file shows the following info: 
</Siginfo_t> 
Signal #11 (SIGSEGV): si_addr is 0x070000286FFFFFFC, si_code is 
0x00000032 (SEGV_MAPERR:Address not mapped to object.) 
</SignalDetails> 
<Registers> 
    IAR: 090000001C50ABCC     MSR: A00000000000D032      LR: 
090000001C50AE40 
    CTR: 0000000000000000     XER: 0000000C           FPSCR: 
82020000 
     CR: 88224044 
GPR[00]: 0000000000000022 GPR[01]: 07000018FAFED9A0 GPR[02]: 
09001000A42CE598 
GPR[03]: 0000000000000000 GPR[04]: 07000029801BA660 GPR[05]: 
070000287000000C 
GPR[06]: 07000018FAFEDB50 GPR[07]: 0000000000000000 GPR[08]: 
0700001B05A502A0 
GPR[09]: 090000001D1411A8 GPR[10]: 00000000FCEDDECF GPR[11]: 
0000000000000000 
GPR[12]: 090000001C50AE14 GPR[13]: 0000000126373800 GPR[14]: 
09001000A42C8B78 
GPR[15]: 0000000000000000 GPR[16]: 0000000000000000 GPR[17]: 
0000000000000000 
GPR[18]: 07000029807703F8 GPR[19]: 0000000000000000 GPR[20]: 
FFFFFFFF81BEFFFA 
GPR[21]: 070000298077C5E0 GPR[22]: 0000000000000002 GPR[23]: 
0000000000000001 
GPR[24]: 0000000000000000 GPR[25]: 0000000000000000 GPR[26]: 
0700001B05A502A0 
GPR[27]: 0000000000000000 GPR[28]: 070000288097DA50 GPR[29]: 
070000298095E040 
GPR[30]: 0000000000000000 GPR[31]: 0000000000000000 
FPR[00]: 40B09C32C0000000 FPR[01]: 3FF0000000000000 FPR[02]: 
40B09C32C0000000 
FPR[03]: FFF8000000000209 FPR[04]: 3FF0000000000000 FPR[05]: 
0000000000000000 
FPR[06]: 41DFFFFFFFC00000 FPR[07]: 0000000000000000 FPR[08]: 
0000000000000000 
FPR[09]: 0000000000000000 FPR[10]: 0000000000000000 FPR[11]: 
0000000000000000 
FPR[12]: 0000000000000000 FPR[13]: 0000000000000000 FPR[14]: 
0000000000000000 
FPR[15]: 0000000000000000 FPR[16]: 0000000000000000 FPR[17]: 
0000000000000000 
FPR[18]: 0000000000000000 FPR[19]: 0000000000000000 FPR[20]: 
0000000000000000 
FPR[21]: 0000000000000000 FPR[22]: 0000000000000000 FPR[23]: 
0000000000000000 
FPR[24]: 0000000000000000 FPR[25]: 0000000000000000 FPR[26]: 
0000000000000000 
FPR[27]: 0000000000000000 FPR[28]: 0000000000000000 FPR[29]: 
0000000000000000 
FPR[30]: 0000000000000000 FPR[31]: 0000000000000000 
</Registers> 
<POFDisassembly> 
     0x090000001C50ABAC : E9229E90 ld    r9,-24944(r2) 
     0x090000001C50ABB0 : E8880090 ld    r4,144(r8) 
     0x090000001C50ABB4 : 38A5000C addi    r5,r5,12 
     0x090000001C50ABB8 : E9492AC0 ld    r10,10944(r9) 
     0x090000001C50ABBC : 60000000 ori    r0,r0,0x0 
     0x090000001C50ABC0 : 60000000 ori    r0,r0,0x0 
     0x090000001C50ABC4 : 60000000 ori    r0,r0,0x0 
     0x090000001C50ABC8 : 60210000 ori    r1,r1,0x0 
>>>> 0x090000001C50ABCC : 80E5FFF0 lwz    r7,-16(r5) 
     0x090000001C50ABD0 : 38A5FFF0 addi    r5,r5,-16 
     0x090000001C50ABD4 : 7C075040 cmpl    cr0,r7,r10 
     0x090000001C50ABD8 : 4082FFF4 bne        cr0,0x1C50ABCC # 
4,bit2 
     0x090000001C50ABDC : E8E5FFF4 ld    r7,-12(r5) 
     0x090000001C50ABE0 : 2C270000 cmpi    cr0,r7,0 
</POFDisassembly> 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x090000001C50ABCC 
sqlngMemBlockLookup__FP9sqlng_blkPvUlRP15sqlngSectObject + 0x11C 
0x090000001C50AE3C sqlngSectSetPtrInternal__FP9sqlng_blkPvT2Ul 
+ 0x148 
0x090000001A681264 
sqlng_build_DATAPARTMAP_obj__FP9sqlng_blk16sqlri_ctree_typeP9sql 
nq_ftbPP17sqlri_datapartmap + 0x500 
0x090000001BB7D8E4 
sqlng_build_TAOB_obj__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb 
+ 0xE98 
0x090000001A6B0F70 
sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb + 
0x4BC 
0x090000001A6F3760 
sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb@glue 
1678 + 0x94 
0x090000001A605700 
sqlng_process_scan_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x1A8 
0x090000001C5065E0 
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x1B8 
0x090000001C505C94 
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x208 
0x090000001BB8B25C 
sqlng_process_delete_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x45C 
0x090000001C5065E0 
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x1B8 
0x090000001C505C94 
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x208 
0x090000001C50595C 
sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator + 
0x1E8 
0x090000001C50339C 
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x1AC 
0x090000001C508530 sqlng_main__FP9sqlnq_qur + 0x6E4 
0x090000001C9D153C sqlng_main__FP9sqlnq_qur@glue17A4 + 0x10C 
0x090000001C9D10B0 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur + 0x308 
0x090000001C8865C8 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env + 0x40 
0x090000001C9ACE1C 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ 
LOCK_INFOP16sqlra_cached_varPiPUl + 0x7F4 
0x090000001C9AA5B8 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb + 0x5E0 
0x090000001C9A71B0 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x708 
0x090000001C9A4470 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x140 
0x090000001C9A4210 
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x25C 
0x0900000019908110 executeSection__10pvmPackageFP5sqlcaUib + 
0x670 
0x090000001A2E5D60 executeQuery__3PVMFUib + 0x1A4 
0x090000001A2E4A60 run__3PVMFv + 0x454 
0x090000001A2E2298 pvm_entry + 0x460 
0x090000001C76CB5C sqloInvokeFnArgs + 0xCC 
0x090000001A17CE80 sqloInvokeFnArgs@glue4C1 + 0x78 
0x0900000018CC20A4 
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntfb + 
0x1E0 
0x090000001C76A3E0 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x100 
0x090000001C990EE8 sqlricall__FP8sqlrr_cb + 0x198 
0x090000001C7E8B84 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm 
+ 0x28 
0x090000001C9A4874 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x544 
0x090000001C9A4210 
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x25C 
0x090000001C9A3EBC 
sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0x850 
0x090000001C9A35FC 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x1C 
0x090000001C7A971C 
.sqljsParse.fdpr.clone.77__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s 
qeAgentb + 0x240 
0x090000001C791D44 
@63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xAA8 
0x090000001C586658 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA0 
0x090000001C5862CC 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x260 
0x090000001C585D94 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x1EC 
0x090000001C6643D8 RunEDU__8sqeAgentFv + 0x298 
0x090000001C659D58 EDUDriver__9sqzEDUObjFv + 0xE4 
0x090000001C661CFC sqloEDUEntry + 0x260 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use db2 v9.7                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 v9.7 fixpack 11 or above                      * 
****************************************************************
Local Fix:
Solution
The problem is first fixed in db2 v9.7 fixpack 11
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.05.2015
08.10.2015
08.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList