A fix is available
APAR status
Closed as program error.
Error description
A distributed thread calling stored procedure was canceled, stored procedure did a mass delete and cancel happened in commit phase 1 when it was inserting a SYSCOPY record to remember mass delete. In this case we did not reset a pointer correctly, during deallocation db2 got abends S0C4 RC38 and abnormally shutdown.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 11 for z/OS and Db2 12 for z/OS * * users of SQL DELETE without a WHERE clause * * on a table in a segmented table space or * * UTS. * **************************************************************** * PROBLEM DESCRIPTION: * * Soft cancel of a SQL DELETE without * * a WHERE clause * * - on a table in a segmented table * * space or UTS * * - in commit phase 1 processing * * running under a stored procedure * * receives ABEND0C4 RC38 in DSNUGDAL * * OFFSET0250 causing Db2 to crash. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** A SQL DELETE without a WHERE clause (mass delete) on a table in a segmented table space or UTS was executing under a stored procedure. A soft cancel was done (ABEND04E RC00E50013) during commit phase 1 processing. An ABENDS0C4 RC38 in DSNUGDAL +x'0250' then occurred which caused Db2 to crash. The ABEND0C4 occurred after the soft cancel in commit phase 1 processing because the recovery routine did not clear transient information for the thread. This problem could also occur if TRUNCATE TABLE, DROP TABLE, ALTER TABLE ROTATE PARTITION on a table in a segmented table space or UTS is soft cancelled in commit phase 1 processing.
Problem conclusion
Db2 code has been modified to correctly handle soft cancels for the scenarios above.
Temporary fix
Comments
APAR Information
APAR number
PH31461
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-11-10
Closed date
2021-02-09
Last modified date
2021-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73870 UI73871
Modules/Macros
DSNUADP1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
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":"11.0"}]
Document Information
Modified date:
06 March 2021