DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

****************************************************************
* USERS AFFECTED:                                              *
* DPF                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 10.5 fixpack9                                     *
****************************************************************

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.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

02.02.2017
09.02.2017
09.02.2017