This table provides table-level information about the number and types of requests processed by this MUF. It contains one row for every table that has been opened to this MUF. This information is always from the start of the MUF to the current time. This includes the RESTART process done during the MUF enable, all activity for ended jobs, and all activity for active jobs. This table shows a view of the logical activity for comparison purposes with the area logical and physical I/O activity and the summary statistics.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
AREA_NAME
|
CHAR(3) |
No |
Name of area which contains the table. Provided to easily join these rows with the area statistics rows. |
|
BEGIN_TIME
|
TIMESTAMP |
No |
Date and time of the MUF enable. Helpful if saving copies of this current data in a user-defined table as history information. |
|
CURRENT_DATETIME
|
TIMESTAMP |
No |
Current MUF date and time. |
|
DBID
|
SMALLINT |
No |
The database ID which contains this table. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the name of the MUF job name. |
|
TABLE_NAME |
CHAR(3) |
No |
Name of the table. |
|
TOTAL_ADDS
|
DECIMAL(11,0) |
No |
Contains the number of rows added to this table. As a measure of work done, it includes adds attempted but failed and also adds which were reversed during transaction backout. |
|
TOTAL_DELETES
|
DECIMAL(11,0) |
No |
Number of rows deleted from this table. Includes deletes done during transaction backouts reversing an add. |
|
TOTAL_READS
|
DECIMAL(11,0) |
No |
Number of data read type requests against this table. |
|
TOTAL_REQUESTS
|
DECIMAL(11,0) |
No |
Number of data manager requests made against this table. |
|
TOTAL_UPDATES
|
DECIMAL(11,0) |
No |
Number of updates to this table. Includes updates done during transaction backouts reversing updates or deletes. |
|
Copyright © 2014 CA.
All rights reserved.
|
|