IBM Support

PI84462: AUTONOMOUS STORED PROCEDURE CALLS ANOTHER STORED PROCEDURE, CAUSES DB2 TO CRASH. ABEND04E RC00D93011 DSNRUC01 +08EE

A fix is available

Subscribe

You can track all active APARs for this component.

 

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

  • RA10 PSY UI51574

       UP17/11/17 P F711

  • RB10 PSY UI51575

       UP17/11/17 P F711

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