IBM Support

IT37084: APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In a DPF configuration, if DDL is issued from an application
    that has connected at a non-catalog partition, then a subsequent
    hang may occur under certain timing conditions if the
    transaction ends up being rolled back shortly after the DDL was
    issued (either due to an internal rollback or external
    rollback).
    
    
    
    The coordinating EDU for this application will be in a stack
    similar to:
    
    
    
    0x0900000000113894 thread_wait + 0x94
    
      0x090000007E72F060 sqloWaitEDUWaitPost + 0xA00
    
      0x090000007F0DFF40 WaitRecvReady__11sqkfChannelFiT1Ci + 0x1220
    
      0x090000007F0EFCA4
    ReceiveBuffer__11sqkfChannelFPP10sqkfBufferi + 0xDC4
    
      0x090000007F175938
    getNextBuffer__18sqkdBdsBufferTableFPP10sqkfBufferP8SQLKD_CB +
    0x1398
    
      0x090000007F163BF4 sqlkd_rcv_buffer__FP8SQLKD_CBPP10sqkfBuffer
    + 0x54
    
      0x090000007F15A994
    IPRA.$sqlkd_rcv_get_next_buffer__FP8SQLKD_CB + 0x54
    
      0x090000007F15C6A0 sqlkd_rcv_init__FP8SQLKD_CBiN22 + 0x240
    
      0x090000007F15D9DC
    sqlkdReceiveReply__FP23SQLKD_RQST_REPLY_FORMAT + 0x89C
    
      0x090000007F4946B4
    sqlkdInterrupt__FP22SQLKD_INTERRUPT_FORMATP5sqlcaP8sqlrr_cb +
    0x20B4
    
      0x090000008040F880
    sqlrr2pd__FP8sqlrr_cbP17SQLR_PE_TRAN_RQSTiPiPP17SQLR_PE_TRAN_RPL
    Y + 0xA40
    
      0x090000008042860C sqlrkrbk__FP8sqlrr_cbP15SQLXA_CALL_INFOi +
    0xF0C
    
      0x09000000809521F0
    sqlrrbck_dps__FP8sqlrr_cbiN22P15SQLXA_CALL_INFOP9SQLP_GXID +
    0x1090
    
      0x090000008094DDB0 sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO
    + 0x1970
    
      0x09000000806DB6EC sqlrr_rollback__FP14db2UCinterface + 0x10C
    
      0x0900000085B11544
    sqljs_ddm_rdbrllbck__FP14db2UCinterfaceP13sqljDDMObject + 0xAC4
    
      0x0900000085A7CD40
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x2E0
    
      0x0900000085A7FD64
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2264
    
      0x0900000085A4AD3C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
    
      0x0900000085A53454
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    
      0x0900000085A48DF0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
    
      0x0900000085A4623C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x33C
    
     0x0900000085A48DF0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
    
      0x0900000085A4623C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x33C
    
      0x090000007E750C20 RunEDU__8sqeAgentFv + 0xB60
    
      0x090000007E72AE40 EDUDriver__9sqzEDUObjFv + 0x300
    
      0x090000007E60BE00 sqloEDUEntry + 0x360
    
    
    
    
    
    At the catalog node, there will be an EDU working on behalf of
    the application with a stack similar to:
    
    
    
     0x0900000000113894 thread_wait + 0x94
    
      0x0900000076B1A060 sqloWaitEDUWaitPost + 0xA00
    
      0x09000000774CAF40 WaitRecvReady__11sqkfChannelFiT1Ci + 0x1220
    
      0x09000000774DACA4
    ReceiveBuffer__11sqkfChannelFPP10sqkfBufferi + 0xDC4
    
      0x0900000077560938
    getNextBuffer__18sqkdBdsBufferTableFPP10sqkfBufferP8SQLKD_CB +
    0x1398
    
      0x090000007754EBF4 sqlkd_rcv_buffer__FP8SQLKD_CBPP10sqkfBuffer
    + 0x54
    
      0x0900000077545994
    IPRA.$sqlkd_rcv_get_next_buffer__FP8SQLKD_CB + 0x54
    
      0x09000000775476A0 sqlkd_rcv_init__FP8SQLKD_CBiN22 + 0x240
    
      0x09000000775489DC
    sqlkdReceiveReply__FP23SQLKD_RQST_REPLY_FORMAT + 0x89C
    
      0x090000007753FF48
    sqleReceiveAndMergeReplies__FP24SQLE_RECEIVE_MERGE_INPUTP25SQLE_
    RECEIVE_MERGE_OUTPUTP5sqlcaP8sqlrr_cb + 0x8C8
    
      0x09000000778804D4
    sqlkdInterrupt__FP22SQLKD_INTERRUPT_FORMATP5sqlcaP8sqlrr_cb +
    0x2ED4
    
      0x0900000077866854 sqlrRpcInterruptSubAgents__FP8sqlrr_cbbPUc
    + 0x454
    
      0x0900000077869420
    sqlrkrpc_nl__FP8sqlrr_cbiN22PCsP15SQLR_RPCMESSAGEP13SQLO_MEM_POO
    LP18SQLR_RPC_REPLY_HDRPbPlUlP19SQLR_BDSREPLY_STATE + 0x1B40
    
      0x0900000078F7142C
    sqlra_broadcast_request_cat__FP8sqlrr_cbP20SQLR_RPC_APM_REQUESTP
    b + 0xBEC
    
      0x090000007B68F678
    sqlrk_apm_router__FP8sqlrr_cbP23SQLKD_RQST_REPLY_FORMATUiPP15SQL
    R_RPCMESSAGE + 0x4F8
    
      0x090000007B68BDDC sqlrr_rpc_router__FP8sqlrr_cb + 0x9FC
    
      0x090000007B689800
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF80
    
      0x090000007B674E94
    IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x7B4
    
      0x090000007B66EF38 sqleProcessSubRequest__FP8sqeAgent + 0x2C38
    
      0x0900000076B3BAAC RunEDU__8sqeAgentFv + 0x9EC
    
      0x0900000076B15E40 EDUDriver__9sqzEDUObjFv + 0x300
    
      0x09000000769F6E00 sqloEDUEntry + 0x360
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

  • Local Fix
    

Comments

APAR Information

  • APAR number

    IT37084

  • 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

    2021-06-01

  • Closed date

    2022-04-18

  • Last modified date

    2022-04-18

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

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

    IT37102

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
03 May 2022