AREA_NAME

CHAR(3)

No

DATACOM-NAME of the area.

AREA_SQLNAME

CHAR(32)

No

If any table in the area is defined in CA Datacom Datadictionary as having SQL-INTENT, this contains the SQLNAME of the area. It is blank if any table in the area is not defined in CA Datacom Datadictionary as having SQL-INTENT. It is also blank after a previous Version to a current Version conversion, until the next catalog of the database.

BINARY_SEARCH

CHAR(1)

No

Contains Y or N. Specifies whether this data area uses the binary search algorithm. Single table areas that do not use compression, and that have a sufficient number of possible rows per block, use a binary search algorithm for speed.

DATA_SPACE_OPTION

CHAR(1)

No

Data space option.

0
No reclamation

1
Random reuse

2
Wrap sequential reuse

3
Clustering reuse

4
Random reuse with OLREORG support

5
Wrap sequential reuse with OLREORG support

DBID

SMALLINT

No

The database identifier.

DIR_LINK

CHAR(1)

No

Specifies whether the CXX link option is in place for this data area. The CXX link option provides an edit to assure an area is being accessed through the correct directory.

DIR_NAME

CHAR(8)

No

Name of the Directory (CXX) used by this MUF.

DYN_EXT_TYPE

CHAR(1)

No

Contains the type of value specified for dynamic extend, blanks if none, C if cylinders, or T if tracks.

DYN_EXT_VALUE

INTEGER

No

Contains the number of tracks or cylinders to request if dynamic extend is selected. Contains a zero if dynamic extend is not selected. When dynamic extend is selected, tracks or cylinders specified here (if not zero) are used during each dynamic extend. If zero here, the VTOC JCL secondary allocation is used. This column is not used during an EXTEND function in DBUTLTY.

DYNAMIC_EXTEND

CHAR(1)

No

Specifies whether dynamic extends are allowed for this data area.

GENERATION

SMALLINT

NO

Value returned is 1 for generation1.

HIGH_URI

DECIMAL(11,0)

Yes

If this area has no loaded table, or if it was loaded with URI=NO, this field is undefined and is set to NULL. For URI, each row in an area is assigned a Unique Row Identifier when it is added or when it is loaded except for a LOAD from a RECID=YES BACKUP. HIGH_URI is the last assigned number.

INSERTS

INTEGER

No

Counter is set to zero during a LOAD. Incremented by one each time a row is inserted by either SQL or record-at-a-time into a table in this area.

LOADED_TIME

TIMESTAMP

Yes

Date and time of area load if any table in the area is loaded. If no loaded table in the area, this field is null.

LOADING

CHAR(1)

No

Specifies whether the area is currently being loaded.

MOVED_RECORDS

INTEGER

No

Number of moved records. Records are moved during an update to a compressed table where the size of stored data is larger and does not fit in the data block. Counter is set to zero during a load. Counter is only an indication of volume of moved records and can range from 0 through 32767 only. You can use this value to help tune SLACK either in the LOAD utility or in the definition of the area in CA Datacom Datadictionary. You can also use it to determine if a reorganize is desirable.

OCCURRENCE

CHAR(32)

No

Contains the CA Datacom Datadictionary entity-occurrence name of this area.

SLACK

SMALLINT

No

Contains the value of SLACK to reserve space in a data block when inserting records. Value is provided through CA Datacom Datadictionary in the area definition. It does NOT relate to the SLACK that can be specified during the LOAD function of DBUTLTY.

STATUS

CHAR(1)

No

Status of the occurrence as provided in CA Datacom Datadictionary. P is production (PROD) status and T is TEST status.

UNLOADING

CHAR(1)

No

Specifies whether the area is currently being unloaded. Unloading reflects that either a BACKUP or an EXTRACT is being done and with either the SEQ=NATIVE, or UPDATE=YES options selected. Other types of BACKUP or EXTRACT are not tracked in the Directory and not available here.

URI

CHAR(1)

Yes

The URI status for an area with no loaded tables is considered unknown and is null. If a loaded table exists, the area is URI or not.

URI_REUSE

CHAR(1)

No

Contains the value (Y or N) specified for the URI-REUSE attribute.

VERSION

SMALLINT

No

Specifies the version of the CA Datacom Datadictionary occurrence for this area.