|
Problem IC65286
|
Status: Closed |
DURING A COM+ TRANSACTION AGAINST DB2 Z/OS, APPLICATIONS MIGHT FACE A SQL0998N ERROR ON THE INITIAL CONNECTION. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
If a COM+ application is using a lower case userid to connect to
a DB2 z/os database, application might see a SQL0998N error
during the first try. If application retries, connection will
work fine.
The reason for the error SQL0998N(failure to enlist the
connections in DTC transaction), is the incorrect case being
used for string comparison for the uid field. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* If a COM+ application is using a lower case userid to *
* connect to a DB2 z/os database, application might see a *
* SQL0998N error during the first try. If application retries, *
* connection will work fine. *
* *
* The reason for the error SQL0998N(failure to enlist the *
* connections in DTC transaction), is the incorrect case being *
* used for string comparison for the uid field. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 2. *
**************************************************************** |
| Local Fix: |
Use an uppercase userid. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 2. |
| Workaround |
Use an uppercase userid. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.12.2009
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
