home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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

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 FixList