DB2 - Problem description
Problem IT09997 | Status: Closed |
ON DPF INSTANCE DATABASE MARKED BAD WITH PROBE SQLKDSENDREPLY, PROBE:8888 | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
On a DPF instance a database may be marked bad when a remote member attempts to reply back to the coordinating member of an application but the coordinating member seems to be "inactive". The following probes can appear in the db2diag.log: 2015-06-03-06.50.02.711955+480 I111135239E551 LEVEL: Severe PID : 13515 TID : 46951613589824PROC : db2sysc 11 INSTANCE: accdb2 NODE : 011 DB : ACCDBDPF APPHDL : 0-53054 APPID: *N0.accdb2.151015130436 AUTHID : ACCDB2 EDUID : 954 EDUNAME: db2agntp (ACCDBDPF) 11 FUNCTION: DB2 UDB, buffer dist serv, sqlkdSendReply, probe:44 RETCODE : ZRC=0x87580092=-2024275822=SQLKD_INVALID_CALL "Invalid call parameters for this function, see specific function for rules" 2015-06-03-06.50.02.753174+480 I111135791E1362 LEVEL: Info PID : 13515 TID : 46951613589824PROC : db2sysc 11 INSTANCE: accdb2 NODE : 011 DB : ACCDBDPF APPHDL : 0-53054 APPID: *N0.accdb2.151015130436 AUTHID : ACCDB2 EDUID : 954 EDUNAME: db2agntp (ACCDBDPF) 11 FUNCTION: DB2 UDB, buffer dist serv, sqlkdSendReply, probe:8888 DATA #1 : String, 38 bytes Number of nodes according to this app: DATA #2 : signed integer, 4 bytes 14 DATA #3 : String, 18 bytes sendNode value is: DATA #4 : unsigned integer, 2 bytes 0 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002AAAABC518D2 pdLog + 0x398 [1] 0x00002AAAACCE0297 _Z14sqlkdSendReplyP16sqlkdRqstRplyFmt + 0x393 [2] 0x00002AAAAD9BFF26 _Z19sqlrkrpc_send_replyP8sqlrr_cbP8SQLKD_CBP15SQLR_RPCMESSAGEP5s qlcai + 0x368 [3] 0x00002AAAAD9BCC2F _Z16sqlrr_rpc_routerP8sqlrr_cb + 0x2FF [4] 0x00002AAAAD9BE488 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xD82 [5] 0x00002AAAACB67EE1 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ + 0x679 [6] 0x00002AAAACB68950 _Z21sqleProcessSubRequestP8sqeAgent + 0xA6 [7] 0x00002AAAABD8B02B _ZN8sqeAgent6RunEDUEv + 0x649 [8] 0x00002AAAAC47BD44 _ZN9sqzEDUObj9EDUDriverEv + 0xA6 [9] 0x00002AAAAC47BC9B _Z10sqlzRunEDUPcj + 0x9 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.5 FIXPACK 7. * **************************************************************** | |
Local Fix: | |
Solution | |
The problem is firstly fixed on V10.5 FIXPACK 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.07.2015 20.01.2016 20.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |