The MUF_TCB_OR_SRB Dynamic System Table is similar to the MUF EOJ TCB Use Summary Information report produced at MUF EOJ. Therefore, for additional information see the CA Datacom/DB DBUTLTY Reference Guide.
Statistics provided by this table are updated periodically by the specific subtask. The information in this table is not completely current, but it does provide performance information with minimal impact.
The MUF_TCB_OR_SRB table contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
CPU_SECONDS
|
INTEGER |
No |
Total CPU seconds used by this task for the life of this MUF. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF startup option or the MUF job name. |
|
PROGRAM_NAME
|
CHAR(8) |
No |
Name of the program using this TCB or SRB. See the list from the DBUTLTY EOJ report in the CA Datacom/DB DBUTLTY Reference Guide. |
|
PHYSICAL_IO
|
DECIMAL(11,0) |
No |
The number of I/Os this TCB or SRB performed. |
|
SEQUENCE_NUMBER
|
SMALLINT |
No |
A sequence number which uniquely identifies a task, where more than one share the same PROGRAM_NAME (for example, DBSMPPR). |
|
TASK_TYPE
|
CHAR(4) |
No |
Contains MAIN for the main MUF task, SMP for SMP subtask, or SUB for other subtask. |
|
TIMES_POSTED
|
DECIMAL(13,0) |
No |
Lists number of times individual TCBs or SRBs went into a wait (no work to do) and were posted to start processing. Once any of the TCBs are posted, they run (and take new work) until no work exists to be done. The information provided in this field could be useful in tuning the ready-to-run option on the SMPTASK Multi-User startup option. |
|
TIMES_USED
|
DECIMAL(13,0) |
No |
The number of times an internal unit of work was performed by this task. Each program has its own considerations for what a unit of work is, which means that this count is therefore not comparable to other CA Datacom counters. |
|
Copyright © 2014 CA.
All rights reserved.
|
|