In this table, one row exists for every area that has been opened by the MUF including the control areas Directory (CXX), Log Area (LXX), and Force Area (FXX), and for user index and data areas.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
AREA_NAME |
CHAR(3) |
No |
Area name. Includes the Directory (CXX), Log Area (LXX), Force Area (FXX), Index Area (IXX), Statistics and Diagnostics Area (PXX) and user data areas. |
|
BEGIN_TIME |
TIMESTAMP |
No |
The date and time of the MUF enable. |
|
CURRENT_DATETIME |
TIMESTAMP |
No |
The current date and time. |
|
DBID |
SMALLINT |
No |
The database ID for a data area or the index to a data area. It is zero for the Directory, Log Area, Force Area, and the Statistics and Diagnostics Area (PXX). |
|
LOGICAL_READS |
DECIMAL(11,0) |
No |
Logical read of any block in this area. A Directory, log, index, or data block having been physically read from DASD may stay in memory and be used again and again. Each of these uses is a logical read. |
|
LOGICAL_WRITES |
DECIMAL(11,0) |
No |
Logical write of any block in this area. An add, update, or delete of a record generates one logical write to the data area. |
|
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. |
|
PHYSICAL_READS |
DECIMAL(11,0) |
No |
Number of I/O requests made against this area to read one or more blocks of DASD information. |
|
PHYSICAL_WRITES |
DECIMAL(11,0) |
No |
Number of I/O requests made against this area to write one or more blocks of DASD information. |
|
Copyright © 2014 CA.
All rights reserved.
|
|