DB2 - Problembeschreibung
Problem IC70125 | Status: Geschlossen |
CONNECTION LEVEL LOAD BALANCING OCCURS EVEN WHEN ENABLEWLB IS NOT SET | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problembeschreibung: | |
LUW client automatically enables Connection level load balancing by default if connection is made directly to DB2 for zOS even when transaction level load balancing (enableWLB) is not enabled. The initial ( very first) connection uses the the connectivity information to route the connection to DB2 for zOS sever. The subsequent new connections are distributed and routed based on the sysplex information returned as server list by the server.The connections are distributed by client instead of sysplex distributor DVIPA. This also prevents single member access on DB2 for zOS. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 Connect * **************************************************************** * PROBLEM DESCRIPTION: * * LUW client automatically enables Connection level load * * balancing * * by default if connection is made directly to DB2 for zOS * * even * * when transaction level load balancing (enableWLB) is not * * * * enabled. * * * * * * * * The initial ( very first) connection uses the the * * connectivity * * information to route the connection to DB2 for zOS sever. * * The * * subsequent new connections are distributed and routed based * * on * * the sysplex information returned as server list by the * * * * server.The connections are distributed by client instead of * * * * sysplex distributor DVIPA. This also prevents single member * * * * access on DB2 for zOS. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Connect V97.fp3a. * **************************************************************** | |
Local-Fix: | |
Connection-level WLB can be explicitly disabled by setting either 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 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in DB2 Version 9.7 Fix Pack 3a | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.07.2010 28.10.2010 11.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3, 9.7.FP3A | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |