One row exists for this table for every Index Area in the Directory (CXX). Each row includes information that exists for that specific Index Area, except for the data set information that is in the DIR_DATASET table. Changes to the DIR_DATASET (DRZ) table in Version 12.0 provide information about multiple index data sets. For reporting, the DIR_INDEX and the DIR_DATASET tables can be easily joined, as can most of the Dynamic System Tables.
The DIR_INDEX contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
AREA_NAME
|
CHAR(3) |
No |
Datacom name of this index area, such as IXX for standard indexes or other values for partitioned indexes. |
|
DBID
|
SMALLINT |
No |
The database identifier (database ID). |
|
DIR_LINK
|
CHAR(1) |
No |
Specifies whether the CXX link option is in place for this Index Area. The CXX link option provides an edit to help ensure that an area is being accessed through the correct Directory (CXX). |
|
DIR_NAME
|
CHAR(8) |
No |
Name of the Directory (CXX) used by this MUF. |
|
DYNAMIC_EXTEND
|
CHAR(1) |
No |
Specifies whether dynamic extends are allowed for this Index Area. |
|
DYN_EXT_TYPE
|
CHAR(1) |
No |
Contains the type of value specified for dynamic extend. Blank 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 field is not used during an EXTEND function in DBUTLTY. |
|
INDEX_LEVELS
|
SMALLINT |
No |
The count of the number of high-level index levels. |
|
OLDEP
|
CHAR(1) |
No |
Contains a Y or N to indicate whether this Index Area was initiated with OLDEP (old entry point) support. The index works more efficiently with OLDEP N. |
|
Copyright © 2014 CA.
All rights reserved.
|
|