IBM Support

IT33112: DB2 MIGHT TRAP DURING A ZIGZAG-JOIN

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

  • Db2 might trap when performing a zigzag join in the following
    stack:
    
    sqldFixExistingTCB
    sqldLockTableFixTCB
    sqldScanOpen
    sqlriopn
    sqlritib
    sqlriZZOpenDims
    sqlriZZInit
    sqlriZigZagJoin
    sqlriSectInvoke
    sqlrr_smp_router
    sqlrr_subagent_router
    IPRA.$sqleSubRequestRouter
    sqleProcessSubRequest
    sqeAgent::RunEDU
    sqzEDUObj::EDUDriver
    
    The db2diag.log message reports the following message:
    
    2019-10-14-18.07.40.068924+120 I3097057A2174 LEVEL: Severe
    PID : 15008212 TID : 69192 PROC : db2sysc
    INSTANCE: db2jkl NODE : 000 DB : JKL
    APPHDL : 0-55842 APPID: 10.18.114.70.40661.191014151404
    UOWID : 352 ACTID: 216448
    AUTHID : SAPSR3 HOSTNAME: hal9000
    EDUID : 69192 EDUNAME: db2agnts (JKL) 0
    FUNCTION: DB2 UDB, data management, sqldFixExistingTCB,
    probe:13569
    MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
    "non-severe dms programming error"
    DIA8532C An internal processing error has occurred.
    DATA #1 : String, 17 bytes
    Expected TEMP TCB
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33112

  • 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

    2020-06-08

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

    IT33113

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:
01 April 2021