DB2 FOR LUW / DB2FORLUW / A10 - DB2

Running db2advis on a database that was created in Oracle 
compatibility mode (db2set DB2_COMPATIBILITY_VECTOR=ORA) to 
recommend DPF partitioning can cause DB2 to trap. 
 
The stack trace can include the following: 
 
</Siginfo_t> 
Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is 
0x00000033 (SEGV_ACCERR:Invalid permissions for mapped object.) 
</SignalDetails> 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000017BD4E94 
sqlnx_exp_insert_row__FP16sqlnx_exp_fidtidPP10SQLD_VALUE + 0x1AC 
0x090000001B890520 
sqlnx_advise_part_row__FPUciT1N22T1T2T1T2UiT1dT1 + 0x1DC 
0x0900000019A65C68 
@124@sqlnx_exp_ADVISE_PART_row_common__FP23sqlnx_exp_lolepop_par 
msPUc + 0x2B8 
0x0900000019A29B80 
sqlnx_exp_ISCAN_analyze__FP23sqlnx_exp_lolepop_parms + 0x35C 
0x0900000019A4A710 
sqlnx_exp_analyze_plan__FP23sqlnx_exp_lolepop_parms + 0x60C 
0x0900000019A4B1F8 
sqlnx_exp_analyze_plan__FP23sqlnx_exp_lolepop_parms + 0xBC 
0x0900000019A4B1F8 
sqlnx_exp_analyze_plan__FP23sqlnx_exp_lolepop_parms + 0xBC 
0x0900000019A4B1F8 
sqlnx_exp_analyze_plan__FP23sqlnx_exp_lolepop_parms + 0xBC 
0x0900000019A4B1F8 
sqlnx_exp_analyze_plan__FP23sqlnx_exp_lolepop_parms + 0xBC 
0x0900000019A4B1F8 
sqlnx_exp_analyze_plan__FP23sqlnx_exp_lolepop_parms + 0xBC 
0x090000001B86A8E8 sqlnx_explain_plan__FP9sqlnq_qur + 0x87C 
0x090000001B869FB0 sqlnx_explain_plan__FP9sqlnq_qur@glue750 + 
0x74 
0x0900000017D80DD4 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur + 0x1B9C 
0x090000001BD1D5C8 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env + 0x40 
0x090000001BE43E1C 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ 
LOCK_INFOP16sqlra_cached_varPiPUl + 0x7F4 
0x090000001BE415B8 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb + 0x5E0 
0x090000001BE3E1B0 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x708 
0x0900000017DA639C 
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x2B0 
0x090000001A592FA8 
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0xC84 
0x0900000017E7399C 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x1E8 
0x090000001BC4071C 
.sqljsParse.fdpr.clone.77__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s 
qeAgentb + 0x240 
0x090000001BC28D44 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0xAA8 
0x090000001BA1D658 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA0 
0x090000001BA1D2CC 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x260 
0x090000001BA1CD94 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x1EC 
0x090000001BAFB3D8 RunEDU__8sqeAgentFv + 0x298 
0x090000001BAF0D58 EDUDriver__9sqzEDUObjFv + 0xE4 
0x090000001BAF8CFC sqloEDUEntry + 0x260 
</StackTrace>

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users running on db2 v10.1 below FP 4.                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 V10.1 fix pack 4 or above.                         * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

21.11.2013
07.07.2014
07.07.2014