|
Problem IC97840
|
Status: Closed |
RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONING IN ORACLE COMPATIBILITY MODE CAN CAUSE DB2 TO TRAP |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users running DB2 10.5 before Fix Pack 3 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 Fix Pack 3 or above. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.11.2013
22.09.2014
22.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
