Previous Topic: DIR_TABLE (DRT)Next Topic: Multi-User Facility Related Tables


DIR_VOLUMES (DRV)

Volume information is NOT stored in the Directory (CXX) however, the data set name is known most of the time in z/OS and also in z/VSE when CA-DYNAM/D is in use. In the case where the data set name is known, the z/OS catalog or CA-DYNAM/D catalog is queried to get a list of volume serial numbers for cataloged areas. Each known volume serial number for each data set is represented in this table with a unique record.

Column Name

SQL Data Type

Nullable

Description

AREA_NAME

 

CHAR(3)

No

Contains CXX for the Directory row, IXX for each Index Area row, or the data area name for each data area row.

DBID

 

SMALLINT

No

Contains zero for the Directory row, else contains the database ID where the area is contained.

DIR_NAME

 

CHAR(8)

No

Contains the name of the Directory used by the MUF.

VOLSER

 

CHAR(6)

No

Volume serial number which contains one or more extents of this area.

VOLUME_SEQ

 

SMALLINT

No

Within one area, contains the sequence number of this volume serial. The volume containing the first extent (or set of extents) has a sequence number of 1. The volume (if any) containing the next extent (or set of extents) has a sequence number of 2, and so forth.