Fixes are available
APAR status
Closed as fixed if next.
Error 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>
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.
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. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT24407
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-03-18
Closed date
2018-05-22
Last modified date
2018-05-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB10 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
22 May 2018