DB2 FOR LUW / DB2FORLUW / 970 - DB2

'db2set -all' command shows DB2TCP_CLIENT_CONTIMEOUT is set. 
 
If federated server option DB2_TWO_PHASE_COMMIT is set to 'Y' 
 
# db2 "select * from schema1.nickname1" 
SQL30080N  A communication error "-3" occurred sending or 
receiving data from the remote database.  SQLSTATE=08001 
 
If federated server option DB2_TWO_PHASE_COMMIT is set to 'N' 
 
# db2 "select * from schema1.nickname1" 
SQL1042C  An unexpected system error occurred.  SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* The user is running DRDA wrapper and                         * 
* DB2TCP_CLIENT_CONTIMEOUT is set.                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 or Federation Server V97FP9.                  * 
****************************************************************

Set ConnectTimeout using db2cli.ini  instead 
of registry variable DB2TCP_CLIENT_CONTIMEOUT.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is firstly fixed on DB2 or Federation Server 
V97FP9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC91776 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

30.01.2013
17.12.2013
17.12.2013

9.7.FP9