DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* 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.    * 
****************************************************************

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.

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
 

First fixed in DB2 UDB Version 9.7 FixPak 4

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.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

29.07.2010
09.05.2011
16.03.2012

9.7.