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 IC70268 Status: Geschlossen

CONNECTING TO DB2 TRANSACTION MANAGER (TM) DATABASE MAY FAIL.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
This problem only exists in DB2 Type 2 connections to DB2 
Transaction Manager (TM) database defined by database manager 
configuration parameter TM_DATABASE, where you're using DB2 
transaction manager. 
Applications using XA-compliant transaction managers such as IBM 
CICS, IBM WebSphere MQ are not affected. 
 
If you once fail to establish DB2 Type 2 connection to a DB2 TM 
database, subsequent attempts to connect to the DB2 TM database 
from the same DB2 client may fail. 
Here are some typical scenarios: 
1) Connecting to the TM database using invalid user name or 
password and encounters SQL0859N. 
   Subsequent attempts encounter SQL0859N even if using correct 
user name and password. 
2) Connecting to the TM database where database manager is not 
started up and encounters SQL0859N. 
   Subsequent attempts encounter SQL0842N even if the database 
manager has been started up. 
 
The error code for subsequent failures varies depending on the 
error code for the initial failure. 
 
The fix of the issue resets connection attributes upon any 
failure when connecting to DB2 TM database. 
As a result, you would have to set the attributes prior to the 
next CONNECT TO command, e.g. "SET CLIENT CONNECT 2" to enable 
Type 2 connection attribute.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This problem only exists in DB2 Type 2 connections to DB2    * 
* Transaction Manager (TM) database defined by database        * 
* manager configuration parameter TM_DATABASE, where you're    * 
* using DB2 transaction manager.                               * 
* Applications using XA-compliant transaction managers such as * 
* IBM CICS, IBM WebSphere MQ are not affected.                 * 
*                                                              * 
* If you once fail to establish DB2 Type 2 connection to a DB2 * 
* TM database, subsequent attempts to connect to the DB2 TM    * 
* database from the same DB2 client may fail.                  * 
* Here are some typical scenarios:                             * 
* 1) Connecting to the TM database using invalid user name or  * 
* password and encounters SQL0859N.                            * 
* Subsequent attempts encounter SQL0859N even if using         * 
* correct user name and password.                              * 
* 2) Connecting to the TM database where database manager is   * 
* not started up and encounters SQL0859N.                      * 
* Subsequent attempts encounter SQL0842N even if the           * 
* database manager has been started up.                        * 
*                                                              * 
* The error code for subsequent failures varies depending on   * 
* the error code for the initial failure.                      * 
*                                                              * 
* The fix of the issue resets connection attributes upon any   * 
* failure when connecting to DB2 TM database.                  * 
* As a result, you would have to set the attributes prior to   * 
* the next CONNECT TO command, e.g. "SET CLIENT CONNECT 2" to  * 
* enable Type 2 connection attribute.                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 FixPak 4 or higher levels.    * 
****************************************************************
Local-Fix:
1. Terminate the DB2 client (e.g. terminate 'db2bp' process by 
"TERMINATE" command) and restart a new one. 
   The new DB2 client will work well until next time you get a 
failure and run into the same problem again. 
2. Using XA-compliant transaction managers instead of DB2 
transaction manager.
verfügbare FixPacks:
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 UDB Version 9.7 FixPak 4
Workaround
1. Terminate the DB2 client (e.g. terminate 'db2bp' process by 
"TERMINATE" command) and restart a new one. 
The new DB2 client will work well until next time you get a 
failure and run into the same problem again. 
2. Using XA-compliant transaction managers instead of DB2 
transaction manager.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.07.2010
09.05.2011
16.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.4 FixList