home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT09943 Status: Closed

ON DPF INSTANCE DATABASE MARKED BAD WITH PROBE SQLKDSENDREPLY, PROBE:8888

product:
DB2 FOR LUW / DB2FORLUW / 970 - 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 V97 Fixpack 11 or later.                      * 
****************************************************************
Local Fix:


Solution


he problem is firstly fixed on DB2 V97 Fixpack 11.


Workaround


not known / see Local fix


Timestamps


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

09.07.2015
09.10.2015
09.10.2015


Problem solved at the following versions (IBM BugInfos)


9.7.FP11



Problem solved according to the fixlist(s) of the following version(s)


9.7.0.11

FixList