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 |  | 







 
