|
Problem IC82809
|
Status: Closed |
During Xa connect,CLI encounter errors SQL0843N, CLI0119E, when using different name for dbalias and dsn |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When customer used "SQLSetConnectAttrw 1 SQL_ATTR_ENLIST_IN_DTC
1" after sqldriverconnect. CLI_dtcEnlistInTransaction will call
SQLConnect2 which in turn will call XA to upgrade the existing
connection. In sqlconnect2 code cli passing wrong dbalias
(because in first connect i.e sqldriverconnect2(). sqlconnect2()
call we are swapping dbalias_name with dsn_name. so during XA
connect instead of sending dbalias for further processing CLI is
sending dsn_name) for cli_slqconnect() and we encounter above
errors during setting of accounting information thru sqe api
sqle_set_info_opt() |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade the DB2 server to V9.7 Fix Pack 7 or above *
**************************************************************** |
| Local Fix: |
As workaround customer can use same name for both dbalias and
dsn
Issued is first fixed in v97fp7 |
| available fix packs: |
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
|
| Solution |
This problem has first been fixed in DB2 V9.7 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87914
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.04.2012
30.10.2012
30.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
