|
Problem IT24407
|
Status: Closed |
TRAP IN SQLBPFADDTOQ WHEN RUNNING A QUERY INVOLVING A FETCH-IXSCAN PLAN AGAINST A BLU TABLE. |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Related StackTrace:
101 <StackTrace>
102 -------Frame------ ------Function + Offset------
103 0x090000004A12B1F8
sqlbpfAddToQ__FP12SQLB_GLOBALSPP14SQLB_pfRequest + 0xF8
104 0x090000004A135ABC
sqlbpfTriggerListPrefetch__FPUiUiPcT2P16SQLB_OBJECT_DESCP12SQLB_
GLOBALSUsT2T719SQLB_pfPriorityTypeP25SQLB_pfRelate
dRequestInfoT1PUs + 0xE7C
105 0x090000005D773F1C
prefetchPageList__Q3_7ibm_cde4data24DatabasePrefetchAccessorCFPU
iCUiCUsPcT2T4T1PUs + 0x11C
106 0x090000005CD684F4
prefetchPageList__Q3_7ibm_cde4data21DatabaseTableAccessorCFPUiCU
iCUsPcT2T4T1PUs + 0x24
107 0x0900000061533598
prefetchPageList__12cdeInterfaceFP8sqlrr_cbPUiCUiCUsPcT3T5T2PUs
+ 0xA8
108 0x090000004C122380
sqlriCdeFFVPrefetchPages__FP8sqlrr_cbP17sqlriCdeStatementRUiT3 +
0x220
109 0x090000004C123D20 sqlriCdeFastFetchVector__FP8sqlrr_cb +
0x120
110 0x090000004BF9DA18
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x618
111 0x090000004AF16C2C
sqlrr_process_fetch_request__FP14db2UCinterface + 0xD0C
112 0x090000004AF19E64
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0xF84
113 0x090000004FC36940
sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0
114 0x090000004FBD73F8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x298
115 0x090000004FBDA464
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2264
116 0x090000004FBA6D9C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
117 0x090000004FBAF4B4
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
118 0x090000004FBA4E60
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13E0
119 0x090000004FBA22B4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T
+ 0x334
120 0x0900000048E6CCC0 RunEDU__8sqeAgentFv + 0xB60
121 0x0900000048E4F740 EDUDriver__9sqzEDUObjFv + 0x300
122 0x0900000048D3E714 sqloEDUEntry + 0x374
123 </StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Db2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* The workaround is to disable PREFETCHING of non-index *
* columns in a Fetch-IXscan plan by including *
* "COL_FVV_PREFETCH OFF" in *
* registry variable DB2_REDUCED_OPTIMIZATION. *
**************************************************************** |
| Local Fix: |
The workaround is to disable PREFETCHING of non-index columns in
a Fetch-IXscan plan by including "COL_FVV_PREFETCH OFF" in
registry variable DB2_REDUCED_OPTIMIZATION. |
| available fix packs: |
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.03.2018
22.05.2018
22.05.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
