One row exists in this table for every database in the Directory. Each row includes information for that specific database except for the data set information which is in the DIR_DATASET table with an area name of IXX.
Note: Changes in the Version 12.0 DIR_DATABASE Dynamic System Table reflect that the information is for the IXX data set, not all of the index data sets. Columns that were removed from DIR_DATABASE in Version 12.0 were related to index information and can now be found in the DIR_INDEX (DRI) table.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
BASE_FORMAT |
SMALLINT |
No |
Column contains the current database format for this DBID. Formats 1 and 2 were used by prior releases. A base open by Version 15.0 is set to Format 3. |
|
DBID |
SMALLINT |
No |
The database identifier. |
|
DIR_NAME
|
CHAR(8) |
No |
The name of the Directory (CXX) being used. |
|
MAINTENANCE_TIME
|
TIMESTAMP |
Yes |
Date and time that the database definition was last cataloged, or was maintained using the CXXMAINT options except the ALTER option. |
|
OCCURRENCE
|
CHAR(32) |
No |
The entity-occurrence name for the database from CA Datacom Datadictionary. |
|
OPEN_TIME
|
TIMESTAMP |
Yes |
Date and time of the last User Requirements Table open for a table in this database. If the database is currently open for read-only, the date and time can reflect a previous open for update. If the table was opened by multiple tasks concurrently, the date and time can reflect any of the tasks. Can be null if a new database is cataloged and no User Requirements Tables have been opened. |
|
OPEN_UPDATE_TIME
|
TIMESTAMP |
Yes |
Date and time of the last User Requirements Table open for update. If the table was opened by multiple tasks concurrently, the date and time can reflect any of the tasks. Can be null if a new database is cataloged and no User Requirements Tables have been opened. |
|
PARTITION
|
CHAR(1) |
No |
Indicates whether the database is partitioned. See the CA Datacom STAR Administrator Guide for details about partitioning. |
|
READ_ONLY_USERS
|
CHAR(1) |
No |
Reflects whether any of the tables in the database are currently open with an UPDATE=NO User Requirements Table. |
|
REPLICA
|
CHAR(1) |
No |
Indicates whether the database can be replicated. See the CA Datacom STAR Administrator Guide for details about replicating. |
|
RESTART_TIME
|
TIMESTAMP |
Yes |
Is null if a new database is cataloged and the RESTART processing at MUF enable has not occurred for this database nor has the RESET function of DBUTLTY been done for this base (when the database was open). Otherwise, it is the date and time of the last RESTART processing or RESET function for this base. |
|
SQL_SECURITY
|
CHAR(1) |
No |
Indicates whether SQL Security has been selected for the tables in this database. For more information about security, see the CA Datacom Security Reference Guide. |
|
STATUS
|
CHAR(1) |
No |
Specifies the status of the occurrence of the database CA Datacom Datadictionary definition. P is PROD status and T is TEST status. |
|
UPDATE_OWNER
|
CHAR(8) |
Yes |
If this DBID is open for update, this is the job name from the last open for update. If this DBID is not open for update, this column is null. |
|
UPDATE_USERS
|
CHAR(1) |
No |
Specifies whether the database is currently open for update. |
|
VERSION
|
SMALLINT |
No |
Specifies the version of the occurrence of the database CA Datacom Datadictionary definition. |
|
Copyright © 2014 CA.
All rights reserved.
|
|