Previous Topic: DIR_DATASET (DRZ)Next Topic: DIR_ELEMENT (DRE)


DIR_DIRECTORY (DRD)

A single row exists in this table to provide information about the Directory in general. Also Directory information is provided with one row in the DIR_DATASET table with a database of zero and an area name of CXX.

Column Name

SQL Data Type

Nullable

Description

AREAEV

 

CHAR(1)

No

This column contains the current setting for Dataset Extent Validation, Y or N. This can be changed by running CXXMAINT.

CURRENT_DATETIME

 

TIMESTAMP

No

Current timestamp from the MUF where the request as processed.

CXX_ENQ

 

CHAR(8)

No

This column contains the level of CXX locking in effect, either LOCAL or SYSPLEX. This can be changed by running CXXMAINT.

CXX_LEVEL

 

SMALLINT

No

The CXX compatibility level.

CXX_VERSION

CHAR(6)

No

The directory's version, for example '14.0' (that is 14.0 plus two blanks to make six characters). Note that Version 15.0 runs with a CXX_VERSION setting at 14.0.

DATACOM_TYPE

 

CHAR(2)

No

Type of CA Datacom/DB Directory being processed. DB for full CA Datacom/DB or AD for a restricted CA Datacom/AD Directory.

DATAFS

 

CHAR(1)

No

This column contains the current setting for Data Fast Search, Y or N. This can be changed by running CXXMAINT.

DATAHU

 

CHAR(1)

No

This column contains the current setting for the Data High Used Mark, Y or N. This can be changed by running CXXMAINT.

DBCS_DEFAULT_MIXED

 

CHAR(1)

No

Specifies a default that character fields are assumed to be Single Byte Character Set (S) or Mixed characters (M) allowing shift out/in characters.

DBCS_SHIFT_CODES

 

CHAR(1)

No

Specifies the type of shift codes embedded in the mixed character fields.

I

Represents z/OS

F

Represents Fujitsu MSP

N

Means that the DBCS feature has been disabled in DBUTLTY in CXXMAINT OPTION=ALTER,DBCS= by a value of DBCS=OFF.

DIR_NAME

 

CHAR(8)

No

Name of the Directory used by this MUF.

GENERATION

SMALLINT

No

Value returned is 1 for generation 1.

HIGH_RUN_UNIT

 

INTEGER

No

Either the last run unit number assigned to an executing CA Datacom/DB job or reserved for a job.

LANGUAGE_SUPPORT

 

CHAR(1)

No

K represents that Katakana language support has been enabled. A blank represents no Katakana language support.

PRIMARY_DD_DBID

 

SMALLINT

No

The database identifier of the primary CA Datacom Datadictionary containing the DATA-DICT database and the High-Speed Directory. The DBID is specified as the first value of the Multi-User startup option DICTIONARY.

PRIMARY_DDD_DBID

 

SMALLINT

No

The database identifier of the Data Definition Directory (DDD) used in SQL processing and by products using SQL. The DBID is specified as the second value of the Multi-User startup option DICTIONARY.

SECURE_JOBNAME

 

CHAR(1)

No

This column is provided for compatibility with prior versions.

SECURE_SINGLE_USER

 

CHAR(1)

No

Indicates whether you can run in a Single User environment with security installed. See the CA Datacom/DB Database and System Administration Guide for more information about this topic.

SIMPLIFY_MODE

CHAR(1)

No

This column contains a Y if the CXX was initiated with SIMPLIFY mode as Yes, otherwise, it is N.

SQL_SUPPORT

 

CHAR(1)

No

Indicates if a MUF with Multi-User startup option SQLOPTION has executed.