Displaying reports about stored procedures

Use the Display window to view a report about the procedures in a subsystem or to view a report about a specified stored procedure. The report displays information about the stored procedures that DB2 applications use.


Displaying stored procedures from the Control Center window produces one output line for each stored procedure accessed by a DB2 application with schema=SYSPROC.

Displaying stored procedures from the contents pane produces an output line for each of the selected stored procedures ordered by the procedure's schema name.


The procedures that were created with the Stored Procedure Builder function are also included in the report in the Display window. The language used for Stored Procedure Builder is SQL.


Authorities and privileges

To display reports about stored procedures:
You can only display procedures accessed by DB2.

  1. Open the Display window.

  2. View the report. Report concepts contains an explanation of the information in the report.

Report concepts

The Display window shows information about stored procedures. If procedure commands can issue successfully, the first line of the report shows a message number and: 
- DISPLAY PROCEDURE REPORT FOLLOWS -
If procedure commands cannot issue successfully, then a message displays. The headings for the columns of information in the report are:
PROCEDURE
The name of the stored procedure.
MODULE
The name of the MVS load module that is associated with the stored procedure. If the stored procedure is queued and waiting for the START PROCEDURE command, then this field can contain blanks.
STATUS
The possible values for the status of a stored procedure are:
STARTED
The procedure can process requests.
STOPQUE
DB2 queues requests.
STOPREJ
DB2 rejects requests.
STOPABN
DB2 rejects requests because the procedure terminated abnormally.
ACTIVE
The number of threads currently running the MODULE.
MAXACT
The maximum number of threads that have run the MODULE concurrently since DB2 was started.
QUEUED
The number of threads currently waiting for the procedure to be scheduled.
MAXQUE
The maximum number of threads that waited concurrently for the procedure to be scheduled since DB2 was started.
TIMEOUT
The number of times an SQL CALL statement timed out while waiting for a procedure to be scheduled.

The report contains one or more subsequent lines with information about one or more procedures. If you request information about a procedure that has not been accessed, this line shows:

PROCEDURE "NAME" HAS NOT BEEN ACCESSED

where NAME is the name of the procedure.

The last line of the report shows a message number and the following message:

DISPLAY PROCEDURE REPORT COMPLETE