DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide

Execution Environments

Stored procedures on z/OS and OS/390 execute under the control of DB2. There are two execution environments for stored procedures:

• DB2 Stored Procedure Address Space (DSNSPAS)

• WLM-managed environments

Administration of stored procedures for either environment includes the use of the following commands:

• START PROCEDURE and STOP PROCEDURE, which allow queuing options for callers to dynamically start and stop the ability to use or execute the stored procedure. It is possible to start or stop procedures with the SCOPE(GROUP) option for data sharing

• DISPLAY PROCEDURE provides the ability to display the status of a stored procedure.

The START and STOP can be issued for individual stored procedures or can include wildcards to affect ...