COMM (Communicate with MUF) › COMM EOJ (End MUF Processing) › Summary Reports Produced by the MUF During its EOJ Process › Procedure TCB Use Summary Information

Procedure TCB Use Summary Information

Following is an example of a new report on Task Control Block (TCB) use.

                                             PROCEDURE TCB USE SUMMARY INFORMATION

         LAST         PROCEDURE                              SQL
 TCB  PROGRAM            STARTS     TCB CPU TIME      STATEMENTS
 
   1  B580PA01                5     000:00:00.03               5
    2 B580PA02                5     000:00:00.73               0
    3 ?                       0     000:00:00.00               0
   4  B580PA01                1     000:00:00.00               1
    5 B580PA02                1     000:00:00.14               0
    6 ?                       0     000:00:00.00               0
      7-9                     0     000:00:00.00               0

This page of the report provides the following information:

TCB

Displays the number of TCBs assigned for procedures are indicated. Those that have been used at least once have a detail line. Those never used have only a range reflected under the LAST PROGRAM heading. Nested TCBs are indented by one position to note that they are different from the non-nested TCBs. Nested TCBs are only used when an SQL request is issued by the previous TCB in that nest group.

LAST PROGRAM

Displays the name of the last program to be processed in this TCB. A question mark (?) in a nested TCB is used to reflect it has never been used.

PROCEDURE STARTS

Displays the number of times this particular TCB was selected to process a user procedure (caused by a call procedure or a trigger).

TCB CPU TIME

Displays the hours, minutes, seconds, and sub-seconds of execution time.

SQL STATEMENTS

Displays the number of SQL statements executed from any program that executed in this TCB. This is zero in the last TCB of each nest group.