Fixes are available
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:
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
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022