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