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 IT01529 Status: Closed

"DETECTED CLIENT TERMINATION" ERROR IN DPF ENVIRONMENT

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
On DB2 client side, when application closes a TCP/IP connection 
that is connected to remote DB2 server, a "Detected client 
termination" error might be reported in db2diag.log file on DB2 
server side. 
 
Here is an example of the error on DB2 server side: 
=========================================== 
2014-01-01-01.01.01.123456+123 I224964E544         LEVEL: Error 
PID     : 12345                TID  : 12345678901234PROC : 
db2sysc 2 
INSTANCE: db2inst1             NODE : 002          DB   : SAMPLE 
APPHDL  : 12-345               APPID: 
10.12.34.56.78901.140315123456 
AUTHID  : DB2INST1 
EDUID   : 123                  EDUNAME: db2agent (SAMPLE) 2 
FUNCTION: DB2 UDB, common communication, sqlcctcptest, probe:11 
MESSAGE : Detected client termination 
DATA #1 : Hexdump, 2 bytes 
0x00002AB15C3F3A88 : 3600 
6. 
 
2014-01-01-01.01.01.123457+480 I225509E526         LEVEL: Error 
PID     : 12345                TID  : 12345678901234PROC : 
db2sysc 2 
INSTANCE: db2inst1             NODE : 002          DB   : SAMPLE 
APPHDL  : 12-345               APPID: 
10.12.34.56.78901.140315123456 
AUTHID  : DB2INST1 
EDUID   : 123                  EDUNAME: db2agent (SAMPLE) 2 
FUNCTION: DB2 UDB, common communication, sqlcctest, probe:50 
MESSAGE : sqlcctest RC 
DATA #1 : Hexdump, 2 bytes 
0x00002AB15C3F3AC0 : 3600 
6. 
 
2014-01-01-01.01.01.123458+480 I226036E506         LEVEL: Error 
PID     : 12345                TID  : 12345678901234PROC : 
db2sysc 2 
INSTANCE: db2inst1             NODE : 002          DB   : SAMPLE 
APPHDL  : 12-345               APPID: 
10.12.34.56.78901.140315123456 
AUTHID  : DB2INST1 
EDUID   : 123                  EDUNAME: db2agent (SAMPLE) 2 
FUNCTION: DB2 UDB, base sys utilities, 
sqeAgent::AgentBreathingPoint, probe:10 
CALLED  : DB2 UDB, common communication, sqlcctest 
RETCODE : ZRC=0x00000036=54 
=========================================== 
 
The problem was introduced in DB2 LUW Version 9.7 Fix Pack 9. It 
doesn't exist in Version 9.7 levels prior to Fix Pack 9. 
 
The problem exists in Database Partitioned Feature (DPF) 
environment only. It doesn't exist in single-node environment.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7 DPF environment on Linux, Unix and  * 
* Windows platforms.                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 9.7 Fix Pack 10 or higher levels.  * 
****************************************************************
Local Fix:
The problem can be avoided by setting DB2 registry variable 
DB2CHECKCLIENTINTERVAL=0 on DB2 server side. 
Please note the DB2 server instance must be recycled to pick up 
the change on the registry variable.
Solution
First fixed in DB2 LUW Version 9.7 Fix Pack 10.
Workaround
The problem can be avoided by setting DB2 registry variable 
DB2CHECKCLIENTINTERVAL=0 on DB2 server side. 
Please note the DB2 server instance must be recycled to pick up 
the change on the registry variable.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.05.2014
10.11.2014
10.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList