MUF_ACCESS_AREA (MFN)

Multi-User Facility Related Tables › MUF_ACCESS_AREA (MFN)

MUF_ACCESS_AREA (MFN)

This table contains information about the area level access function. One row exists in this table for every area that has one of the following conditions:

Has been specified in the DBUTLTY function ACCESS specifying both the DBID= and AREA= keywords.
Has been opened by an execution of DBUTLTY function RECOVERY OPTION=BACKWARD.
Has been opened by an execution of a DBUTLTY function that included the keyword MULTUSE=YES (BACKUP, EXTEND, EXTRACT, INIT, LOAD, REORG, RETIX).

Column Name	SQL Data Type	Nullable	Description
AREA_NAME	CHAR(3)	No	Contains the area name.
DBID	SMALLINT	No	Contains the database ID.
MUF_NAME	CHAR(8)	No	Name of the MUF specified in the MUF Multi-User startup option or the MUF job name.
TYPE_ACCESS	CHAR(5)	No	Type of access in effect, OFF or READ (WRITE is implied for missing rows).
TYPE_ACCESS_USER	CHAR(5)	No	Type of access set by user using DBUTLTY ACCESS with DBID and area name. Possible values are OFF, READ, UTLTY, or WRITE.
TYPE_ACCESS_UTLTY	CHAR(5)	No	Type of access set by a DBUTLTY function (BACKUP, EXTEND, EXTRACT, INIT, LOAD, REORG, RETIX) using the keyword MULTUSE=YES (excludes the ACCESS function). Possible values are READ, UTLTY, or WRITE.
WHICH_UTLTY	CHAR(8)	No	Contains blanks if the previously shown TYPE_ACCESS_UTLTY column contains WRITE, else contains BACKUP, EXTEND, EXTRACT, INIT, LOAD, RECOVERY, REORGB, REORGL, or RETIX.

Copyright © 2014 CA. All rights reserved.