COMM (Communicate with Multi-User Facility) › COMM EOJ (End Multi-User Facility Processing) › EOJ Reports › Procedure TCB Use Summary Information

Procedure TCB Use Summary Information

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

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ********************************************************************************
 
                                             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

Œ

Under the TCB heading, 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.



Under the LAST PROGRAM heading is shown 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.

Ž

Under the PROCEDURE STARTS heading is shown the number of times this particular TCB was selected to process a user procedure (caused by a call procedure or a trigger).



Below the TCB CPU TIME heading are found the hours, minutes, seconds, and sub-seconds of execution time.



Under the SQL STATEMENTS heading is shown 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.