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.
Displaying stored procedures from the contents
pane produces an output line for each of
the selected stored procedures ordered by
the procedure's 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:
-
Open the Display window.
-
View the report. Report concepts contains an explanation
of the information in the report.
Report concepts
The Display window shows information about
stored procedures.
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