|
Problem IC66525
|
Status: Geschlossen |
RETURN CODE SQLKD_NOMORE_DATA RECEIVED FOR SQLRKRPC_NL COULD LEAD TO SQLCODE -901. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DPF environment. *
****************************************************************
* PROBLEM DESCRIPTION: *
* 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 the user and the customer could see *
* increased logging in *
* the db2dump directory. *
* *
* The following db2diag.log entry 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 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97 fixpack 2. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
This issue is fixed in v97 fixpack 2. With this fix the customer
should no
longer see SQLKD_NOMORE_DATA returned from sqlrkrpc_nl and a
-901 returned to user. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66587
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.02.2010
08.04.2010
08.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
