|
Problem IC77221
|
Status: Closed |
AUTOMATIC CLIENT REROUTE IS TRIGGERED EVEN IF IT WAS NOT ENABLED BY THE APPLICATION |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
Starting with DB2 9.7 FP3a, the automatic client reroute (ACR)
feature is enabled by default.
With previous versions, if you have disabled Connection-level
WLB by setting one of the following :
1. By setting "ConnectionLevelLoadBalancing=false" in
db2dsdriver.cfg.
2. Catalog a DCS directory without specifying SYSPLEX as a DCS
parameter.
3. Set DISABLESYSPLEX=TRUE in db2cli.ini file
4. Set connection attribute SQL_ATTR_DISABLE_SYSPLEX=1
ACR and connection level load balancing were disabled.
Now, with DB2 9.7 FP3a, only connection level load balancing is
disabled and as a consequence, if your application hits a
communication error with your DB2 server, instead of reporting
an error immediatly, the application will keep retrying the
connection to your DB2 server repeatedly for up to 10 minutes
before returning an error. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP5 *
**************************************************************** |
| Local Fix: |
Disable ACR explicitly
1. by setting registry variable db2set
DB2_MAX_CLIENT_CONNRETRIES=0
2. by setting enableACR=false in db2dsdriver.cfg |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
|
| Solution |
The APAR is first fixed in DB2 9.7 FP5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.06.2011
20.01.2012
20.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
