A fix is available
APAR status
Closed as program error.
Error description
When using RRSAF (Resource Recovery Services Attachment Facility), when an autonomous stored procedure is called which then calls another stored procedure, DB2 crashes with ABEND04E RC00D93011 DSNRGLM1 DSNRUC01 OFFSET08EE
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Db2 for z/OS users of autonomous stored * * procedures. * **************************************************************** * PROBLEM DESCRIPTION: When an autonomous stored procedure is * * called from an RRSAF application an * * ABEND04E RSN00D93011 may occur in * * DSN3RUC01. * * ABEND04E RC00D93011 DSNRUC01 * **************************************************************** * RECOMMENDATION: * **************************************************************** When an autonomous Stored Procedure is called from an RRSAF application an ABEND04E RCN00D93011 may occur in DSN3RUC01. If an autonomous stored procedure is called from an RRSAF application the autonomous Stored Procedure will run under its own Db2 agent and Db2 UR, so Db2 resources and other RRS associated resources updated by the autonomous Stored Procedure or down stream nested WLM managed Stored Procedures will be not be coordinated by RRS on the RRSAF application RRS UR. The RRSAF and autonomous Stored Procedure are running on two distinct Db2 agents and URs. z/OS RRS will not coordinate resources in the RRSAF application RRS UR and the autonomous Stored Procedure.
Problem conclusion
Module DSNRUB01 has been updated to prevent the ABEND04E RC00D93001 when an RRSAF application invokes an autonomous stored procedure.
Temporary fix
Comments
APAR Information
APAR number
PI84462
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-07-13
Closed date
2017-10-25
Last modified date
2019-09-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI51574 UI51575 PH16751
Modules/Macros
DSNRUB01
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.
[{"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":"11.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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 September 2019