DB2 - Problem description
Problem IT19078 | Status: Closed |
DPF: SQL0901N: SQLRA_FREE_SECTION: SECTION NOT CLOSED FROM REMOTE PARTITIONS IN THE AFTERMATH OF A NODE FAILUIRE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
If an application opens a cursor (issues a SELECT statement) that fetches data from a remote partition, and then there is a node failure detected in the DPF system, then a -1229 error will occur and the transaction will be rolled back. This is as expected. When the node failure is resolved, then if the same application opens another cursor using the same statement handle (package and section number), then depending on the timing, the open of this cursor may fail with a -901 sqlcode reported from a remote partition. The db2diag.log would include probes similar to: FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 38 sqlerrmc: sqlra_free_section: section not closed sqlerrp : SQLRA13E sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFF38 (6) 0x00000001 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: Stack Trace -------Frame------ ------Function + Offset------ 0x0900000000568F14 pthread_kill + 0xD4 0x0900000008CC1E74 sqloDumpEDU + 0xD0 0x090000000917C500 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x104 0x0900000009D3AB3C sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x558 0x0900000009D384D4 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28 0x0900000009D38678 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0xCC 0x0900000009D38CB4 sqlrrSqlCode + 0xCC 0x090000000A225E0C sqlra_free_section__FP8sqlrr_cbP25sqlra_sql_context_siblingiN23 + 0x2CC 0x090000000DAA5034 sqlra_get_section_subagent__FP8sqlrr_cbPUcsT2T3T2UsUl + 0xCB8 0x09000000092CADD4 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xFB8 0x09000000092C8A5C @83@sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0xC5C 0x09000000092C4FE4 sqleProcessSubRequest__FP8sqeAgent + 0x3CB0 0x090000000972D6CC RunEDU__8sqeAgentFv + 0x674 0x090000000972C868 EDUDriver__9sqzEDUObjFv + 0x13C 0x090000000972C6F0 sqlzRunEDU__FPcUi + 0x10 0x090000000971E2F4 sqloEDUEntry + 0x264 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DPF * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 10.5 fixpack9 * **************************************************************** | |
Local Fix: | |
If the error is encountered a Unit of Work Rollback will resolve the issue so the -901 sqlcode will no longer be experienced by the application. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.02.2017 09.02.2017 09.02.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |