DB2 - Problem description
Problem IC95642 | Status: Closed |
CLI0106E ERROR OCCURS DUE TO PHYSICAL NETWORK TIMEOUT BY LONG IDLE TIME | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
When under connection pooling, the application can get a connection via OCISessionGet() that is no longer active because of the tcpip keep alive processing which terminated a connection that was idle for more than the default interval (2 hours). CLI does not detect this either as no indication that the connection has been terminated is ever given to the client at any layer. The only way to verify this for sure was to capture a DB2CI trace with TraceTimestamp=1 to see that a given connection was not used in over 2 hours or trace tcpip itself (not sure how to do this). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 4 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in Version 10.1 Fix Pack 4 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC97096 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.09.2013 21.10.2013 21.10.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.3 | |
10.1.0.3 |