IBM Support

IT33204: Hang in multithreaded app when 1 thread is waiting to complete operation while 2nd thread calls SQLGetInfoW() before new conn.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

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

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 2                                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v11.5.5.0 and later.                              *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IT33204

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-06-16

  • Closed date

    2021-06-07

  • Last modified date

    2021-06-07

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT33350

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"11.5"}]

Document Information

Modified date:
08 June 2021