ACTIVE_READS

INTEGER

Yes

This field is null for a database level definition or an area level definition of an unopened area. It is also null for a virtual area. Provides the number of blocks read from disk to support an active covered area which is open or has been open. Also provides the number of blocks read from disk for covered using FIRST.

AREA_NAME

CHAR(3)

No

Contains blanks for a database level definition. Otherwise, it contains a specific area name from either a specific definition or the open of an area in a database with a database level definition but no specific definition for this area.

BEGIN_BLOCK

SMALLINT

Yes

Contains the percent of area blocks used when covered with FIRST option. Contains null if virtual or covered with the ACTIVE option.

BLOCKS_CURRENT

INTEGER

Yes

Contains null if a database level definition or an unopened specific area definition. Otherwise, it contains the number of blocks currently available for use for this specific area.

BLOCKS_MAXIMUM

INTEGER

Yes

Contains null if a database level definition or an unopened specific area definition. Otherwise, it contains the number of blocks allocated for use for this specific area.

DATASPACE

CHAR(1)

Yes

If this field is null, it indicates that this row is a database level definition or an unopened specific area definition. If this field contains a Y, it indicates that this area is in a data space. If this field contains an N, it indicates that normal address space memory is in use. If this field contains an X, it indicates that the space used is 64-bit.
A VIRTUAL area can have its initial allocation in 64-bit or a data space. Later extends only occur in a data space. The value reported here is the initial allocation.

DBID

SMALLINT

No

Contains the database ID of this database.

FIRST_ACTIVE

CHAR(1)

Yes

For database level definitions or specific area definitions to unopened areas, if either did NOT provide the FIRST or ACTIVE option specified, this field can be null. But the field can contain an F to indicate FIRST is to be used, or an A to indicate ACTIVE usage, even if you did not specify an F or an A. See the sections on COVERED FIRST and COVERED ACTIVE in the chapter on the Memory Resident Data Facility in the CA Datacom/DB Database and System Administration Guide for more information.

HIGH_VIRTUAL_BLOCK

INTEGER

Yes

This field contains null except for areas opened in a VIRTUAL database. This field contains the number of the last block in the virtual data set.

MEMORY_SIZE

DECIMAL(11,0)

No

The size for a database definition or an unopened specific area definition is what was provided in the covered or virtual definition. For these definitions with covered, a size value of 1 through 100 represent a percentage of the area to cover. A value greater than 100 represents the number of bytes to cover. Definition sizes ending in K,M,G are converted to bytes for this size field. For an area which has been opened, the size is always the number of bytes and reflects the actual memory allocated. This size for an open area has been rounded up to one block (covered) or one track (virtual), if necessary. Otherwise, it was rounded down to an even number of blocks (covered) or an even number of tracks (virtual).

MRDF_READS

INTEGER

Yes

This field is null in definitions other than areas which have been opened. It contains the number of blocks that were read from the MRDF space instead of from DASD.

MUF_NAME

CHAR(8)

No

Name of the Multi-User Facility specified in the MUF Multi-User startup option or the name of the MUF job name.

NONFIRST_READS

INTEGER

Yes

This field is null in definitions other than covered areas which have been opened and that are being processed with the FIRST option. It contains the number of blocks read from DASD which are higher than the first covered blocks.

TOTAL_READS

INTEGER

Yes

Null if this row is not an opened area. Otherwise, this is the number of blocks in this covered/virtual area that are needed in normal LXX, IXX, or data buffers that are requested from MRDF. For a virtual area, each of these is also considered an MRDF_READ. For a covered area using the FIRST option, each of these is also counted in either the MRDF_READS or the NONFIRST_READS. For a covered area using the ACTIVE option, each of these is also counted in either the MRDF_READS or the ACTIVE_READS.

VIRTUAL_COVERED

CHAR(1)

No

Contains a V to represent a virtual base or a C to represent a covered base.

VIRTUAL_WRITES

INTEGER

Yes

Null unless this is an opened area in a base defined as virtual. For opened virtual areas this is the number of times a block was written from the normal buffers to a MRDF buffer.