IBM Support

IT30761: DB2 MAY RETURN SQL0901N ("COMBINED KEY LENGTH TOO BIG FOR SYSTEMTEMP") WHEN EXECUTING QUERIES INVOLVING ZIGZAG JOINS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • SQL0901N with the message "Combined key length too big for
    system temp" may be returned when executing queries involving
    zigzag joins.
    
    An example stack trace is seen below:
    
    sqlzSetAndLog901 + 0x294
    sqldCreateIndex__FP8sqeAgentP17SQLD_CREATEINX_CB + 0x6D4C
    sqldIndexCreate__FP8sqeAgentP17SQLD_CREATEINX_CB + 0x2D88
    sqlriCreateTempTableIndex__FP8sqlrr_cbP10sqlri_iudoUsT3 + 0x3EC
    sqlrifiswp2__FP8sqlrr_cb + 0x480
    sqldEvalDataPred__FP13SQLD_DFM_WORKPUlP10SQLD_DPRED + 0x3DC
    sqlsfetc__FP8sqeAgentP8SQLD_CCBiP10SQLD_DPREDPP10SQLD_VALUEP8SQL
    Z_RIDPc@OL@24042 + 0x320
    sqlsfetc__FP8sqeAgentP8SQLD_CCBiP10SQLD_DPREDPP10SQLD_VALUEP8SQL
    Z_RIDPc + 0xA4
    sqlriFetch__FP8sqlrr_cbP9sqlri_taol + 0x11C
    sqlrita__FP8sqlrr_cb + 0x1D4
    sqlriZigZagJoin__FP8sqlrr_cb + 0x23E4
    sqlrihsjn__FP8sqlrr_cb + 0xAA0
    sqlriunn__FP8sqlrr_cbP10sqlri_stob + 0x424
    sqlriset__FP8sqlrr_cb + 0x1A8
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x90
    sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x11C8
    sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0xF0
    executeSection__10pvmPackageFP5sqlcaUib + 0x3BC4
    executeSection__10pvmPackageFP5sqlcaUib + 0x12C
    executeQuery__3PVMFUib + 0x100
    run__3PVMFv + 0x124
    pvm_entry + 0xD70
    sqloInvokeFnArgs + 0x1A0
    sqlriInvokeInvoker__FP10sqlri_ufobb + 0xCC
    sqlriInvokeInvoker__FP10sqlri_ufobb + 0x1498
    sqlricall__FP8sqlrr_cb + 0x1E0
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x90
    sqlrr_process_execute_request__FP8sqlrr_cbib + 0xB5C
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x1C4
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x978
    @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x11E4
    @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x11E4
    @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xDD8
    @72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
    @72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC
    RunEDU__8sqeAgentFv + 0x40E1C
    RunEDU__8sqeAgentFv + 0x124
    EDUDriver__9sqzEDUObjFv + 0x130
    sqloEDUEntry + 0x3A0
    _pthread_body + 0xE8
    

Local fix

  • Disable the use of zigzag join via setting the following
    registry setting (it can be applied immediately) either through
    db2set or via a guideline:
    DB2_REDUCED_OPTIMIZATION="ZZJN OFF"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 250                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.6                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30761

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-30

  • Closed date

    2021-03-22

  • Last modified date

    2021-03-22

  • APAR is sysrouted FROM one or more of the following:

    IT30759

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
23 March 2021