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. |
|
Copyright © 2014 CA.
All rights reserved.
|
|