IBM Support

IT37339: A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A user interrupt during an implicit rebind while opening a
    cursor in a stored procedure may cause a trap.
    
    
    Stacktrace will look like this :
    
    sqloEDUCodeTrapHandler + 0x03cb
    csmSetAppPointer(db2UCinterface*, CSM_APP_POINTER*) + 0x0039
    pvmPackage::openCursor(unsigned int) + 0x02dc
    pvmPackage::executeSection(sqlca*, unsigned int, bool) + 0x073f
    PVM::executeQuery(unsigned int, bool) + 0x0101
    PVM::run() + 0x0ce2
    pvm_entry + 0x01ae
    sqloInvokeFnArgs + 0x71d4
    address: 0x00002AAAB36E4374 ; dladdress: 0x00002AAAAB472000 ;
    offset in lib: 0x0000000008272374 ;
    sqlriInvokeInvoker(sqlri_ufob*, bool) + 0x1bb1
    sqlricall(sqlrr_cb*) + 0x01d0
    sqlriSectInvoke(sqlrr_cb*, sqlri_opparm*) + 0x04c3
    sqlrr_process_execute_request(sqlrr_cb*, int, bool) + 0x0f4f
    sqlrr_execute(db2UCinterface*, UCstpInfo*) + 0x02a3
    sqljs_ddm_excsqlstt(db2UCinterface*, sqljDDMObject*) + 0x06c4
    sqljsParseRdbAccessed(sqljsDrdaAsCb*, sqljDDMObject*,
    db2UCinterface*) + 0x010b
    sqljsParse(sqljsDrdaAsCb*, db2UCinterface*, sqeAgent*, bool) +
    0x054e
    address: 0x00002AAAB106F25D ; dladdress: 0x00002AAAAB472000 ;
    offset in lib: 0x0000000005BFD25D ;
    address: 0x00002AAAB1075843 ; dladdress: 0x00002AAAAB472000 ;
    offset in lib: 0x0000000005C03843 ;
    sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) + 0x011f
    sqeAgent::RunEDU() + 0x0de3
    sqzEDUObj::EDUDriver() + 0x01be
    sqloEDUEntry + 0x057a
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.5 FP7 or later                                 *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.5 FP7 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37339

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-06-18

  • Closed date

    2021-11-22

  • Last modified date

    2021-11-22

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

    IT35663

  • 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

  • RB50 PSN

       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.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 December 2021