DB2 - Problem description
Problem IT37084 | Status: Closed |
APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.06.2021 18.04.2022 18.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |