A fix is available
APAR status
Closed as program error.
Error description
When ODBC application trace is enabled, the ODBC threads can deadlock on the mutex and caused more threads to queue waiting for the mutex. Then the applications hung. This problem occurs only when the ODBC application trace is enabled. The hung is in application address space. The SVC 1 wait PSW is within LE module CEEOPMLR. There is a small window when one ODBC thread held H latch and then request AT Latch while the other thread held AT Latch and then request H latch, thus the deadlock.
Local fix
Turn off ODBC application trace because the AT latch is held only when the ODBC application trace is enabled.
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of DB2 11 and 12 for * * z/OS ODBC/CLI driver * **************************************************************** * PROBLEM DESCRIPTION: * * ODBC application may hit a deadlock * * situation and hang when ODBC * * application trace is enabled. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When ODBC application trace is enabled and there are multiple threads running concurrently, a deadlock situation may occur when one thread is attempting to record an SQLAllocEnv() call in the application trace, and another thread is writing the error information to the application trace.
Problem conclusion
The deadlock situation is resolved.
Temporary fix
Comments
APAR Information
APAR number
PI90226
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B17
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-11-14
Closed date
2018-02-01
Last modified date
2018-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI53616 UI53617
Modules/Macros
DSNAOCLI DSNAOC02 DSNAOG02 DSNAOSDK
Fix information
Fixed component name
DB2 ODBC/JDBC/S
Fixed component ID
5740XYR02
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B17"}]
Document Information
Modified date:
03 March 2021