An unexpected return code SQLKD_NOMORE_DATA is received
from a remote procedure call. If a subagent on a coordinator
node fails to receive all of its initialization data due to an
interrupt, an empty reply buffer will be returned.
This should not happen. This empty reply buffer is what leads to
the unexpected SQLKD_NOMORE_DATA that will ultimately
return a -901 to user.
The following db2diag.log entries is a symptom of the issue:
2009-10-23-14.28.34.391051-240 I786186A1539 LEVEL: Error
PID : 1302530 TID : 28208 PROC : db2sysc
33
INSTANCE: svtpdb2 NODE : 033 DB : BIGDB1
APPHDL : 57-3678 APPID: *N57.svtpdb2.091023185438
AUTHID : SVTPDB2
EDUID : 28208 EDUNAME: db2agntp (BIGDB1) 33
FUNCTION: DB2 UDB, relation data serv, sqlrkrpc_nl, probe:1201
MESSAGE : ZRC=0x87580093=-2024275821=SQLKD_NOMORE_DATA
"Receive reached EOF for this stream"
DATA #1 : String, 17 bytes
rpc_reply.msglen:
DATA #2 : unsigned integer, 4 bytes
0
DATA #3 : String, 21 bytes
replyp->reply_buflen:
DATA #4 : unsigned integer, 4 bytes
0
DATA #5 : String, 9 bytes
codepath:
DATA #6 : unsigned integer, 4 bytes
1
CALLSTCK:
[0] 0x0900000022EF6BD8 pdLog + 0x1D8
[1] 0x09000000236A3138
sqlrkrpc_nl__FP8sqlrr_cbiN22PsP15SQLR_RPCMESSAGEP13SQLO_MEM_POOL
P18SQLR_RPC_REPLY_HDRPbPl
+ 0x2558
[2] 0x0900000026A84CA4
sqlra_find_ship_var__FP8sqlrr_cbP13sqlra_ship_idT2iP16sqlra_cach
ed_varP13sqlra_stmt_idPUiT7PiP14SQLP_LOCK_INFO
+ 0x1A84
[3] 0x0900000026A6A8FC
sqlra_get_section_subagent__FP8sqlrr_cbPUcsT2T3T2UsUl + 0xCBC
[4] 0x0900000027FECA48
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x1228
[5] 0x0900000026B28068 sqleSubRequestRouter__FP8sqeAgentPUiT2
+ 0xB28
[6] 0x0900000026B32650 sqleProcessSubRequest__FP8sqeAgent +
0x190
[7] 0x090000002314AA90 RunEDU__8sqeAgentFv + 0x2F0
[8] 0x090000002313A71C EDUDriver__9sqzEDUObjFv + 0x19C
[9] 0x090000002313AA3C sqlzRunEDU__FPcUi + 0x3C |
