|
Problem IT33204
|
Status: Closed |
Hang in multithreaded app when 1 thread is waiting to complete operation while 2nd thread calls SQLGetInfoW() before new conn.
|
| product: |
DB2 CONNECT / DB2CONNCT / B50 - DB2 |
| Problem description: |
In a multi-threaded environment, when thread 1 is waiting for
some operation to complete, SQLGetInfoW() is seen to hang in a
second thread if it is invoked on a new connection handle before
establishing database connection. This problem is seen due to
thread 2 attached to thread 1's context and trying to acquire a
context latch that waits for thread 1 to complete. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* 2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v11.5.5.0 and later. *
**************************************************************** |
| Local Fix: |
NA |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* 2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v11.5.5.0 and later. *
**************************************************************** |
| Comment |
In a multi-threaded environment, when trying to load data into
table using External table in one connection handle
SQLDriverConnect() attempted on the second connection handle is
hanging, internally drivermanager is calling SQLGetInfo before
the connection which is causing the hang. The issue has been
fixed. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.06.2020
07.06.2021
07.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
