Previous Topic: MUF_ACTIVE_TASKS (MFQ)Next Topic: MUF_BUF_CONTENT (MBC)


MUF_AREA_STATS (MFA)

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.