The first line of the report shows a message number and:
- DISPLAY PROCEDURE REPORT FOLLOWS -
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
