A fix is available
APAR status
Closed as program error.
Error description
There is a small window in DSNXEDSC when the job timed out with ABEND322, Db2 issued ABEND0C4 RC00000004 DSNXEUFP OFFSET0119A during deallocation and then Db2 crashed with S04F. Additional Keywords: SQLDYNSTMTCACHE ABEND04F
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 for z/OS users of cached dynamic * * SQL * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 CRASHED WITH S04F AFTER ABEND0C4 * * RC00000004 DSNXEUFP OFFSET0119A * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** There is a small timing window during the SQL PREPARE request where we copy information into the running thread from the cached sql statement. If this copy process is cancelled before it completes, Db2 abends during thread deallocation because the section is in an inconsistent state.
Problem conclusion
The process to copy cached info into the running thread is changed to be atomic to ensure consistency.
Temporary fix
Comments
APAR Information
APAR number
PH20422
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-12-17
Closed date
2020-02-11
Last modified date
2020-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI67813
Modules/Macros
DSNXEDSC
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI67813
UP20/02/19 P F002
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 March 2020