IBM Support

IT24407: TRAP IN SQLBPFADDTOQ WHEN RUNNING A QUERY INVOLVING A FETCH-IXSCAN PLAN AGAINST A BLU TABLE.

Subscribe

You can track all active APARs for this component.

 

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