Starting stored procedures activates the definition of a stored procedure that is
stopped or refreshes one that is stored in the cache. Conversely, stopping stored
procedures prevents Db2 from
accepting SQL CALL statements for one or more stored procedures.
You do not need to start procedures when you define a new stored procedure; Db2 automatically activates the new
definition when it first receives an SQL CALL statement for the new procedure.
Before you begin
Ensure that the Manage Stored Procedures
(ADB2ZP) panel is open.
For instructions on how to navigate to this panel, see Stored procedures.
Procedure
To start or stop all stored procedures:
On theManage Stored Procedures
(ADB2ZP) panel, specify one of
the following options, and press Enter
4
Starts all stored procedures
5
Stops all stored procedures
Db2 Admin Tool issues
the Db2 START
PROCEDURE(*.*) or STOP PROCEDURE (*.*) command as requested, and displays the
status of the command.
The following figure shows example output for START
PROCEDURE:
Figure 1. Start All Stored Procedures panel (ADB2DB2O)
DB2 Admin ------- DB2X Browse DB2 Command Output --- Line 00000000 Col 001 080
Command ===> Scroll ===> PAGE
-STA PROC(*.*)
********************************* Top of Data **********************************
DSNX946I ? DSNX9ST2 START PROCEDURE SUCCESSFUL FOR *.*
DSN9022I ? DSNX9COM '-START PROC' NORMAL COMPLETION
******************************** Bottom of Data ********************************
The following figure shows example output for STOP PROCEDURE:
Figure 2. Stop All Stored Procedures panel (ADB2DB2O)
DB2 Admin ------- DD1A Browse DB2 Command Output --- Line 00000000 Col 001 080
Command ===> Scroll ===> PAGE
-STO PROC(*.*)
********************************* Top of Data **********************************
DSNX947I ? DSNX9SP2 STOP PROCEDURE SUCCESSFUL FOR *.*
DSN9022I ? DSNX9COM '-STOP PROC' NORMAL COMPLETION
******************************** Bottom of Data ********************************