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.


Authorities and privileges

To display reports about stored procedures:

  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