
288 Power Systems Enterprise Servers with PowerVM Virtualization and RAS
Case study
In order to provide a timeout mechanism with the DB2 client, DB2 provides one environment
variable (DB2TCP_CLIENT_RCVTIMEOUT) to enable it. For example, when you set
DB2TCP_CLIENT_RCVTIMEOUT=10, the timeout value is 10 seconds. After enabling this
function, DB2 adds invoking subroutines for each transaction, it includes localtime() and
gettimeofday() and others. If the response time of the transaction is extremely short, for
example, 0.00005s, and you enable this environment variable, the performance difference is
obvious (sometimes more than 10%) between the ...