This table contains access information. One row exists in this table for every database known to the Directory (CXX). This table reflects the Multi-User startup option ACCESS setting, as modified by any utility or console ACCESS changes. The ACCESS can be set for databases which are not currently defined to the Directory, but they cannot, however, be queried with this table.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
DBID |
SMALLINT |
No |
Contains the database ID. |
|
MAINTENANCE
|
CHAR(1) |
No |
Indicates whether maintenance can currently be done to this database. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
OPEN_STATUS
|
CHAR(6) |
No |
Contains the current open status of this database. Contains CLOSED if the MUF does not have this database open. Contains WRITE if this MUF has the database open with update authority. Contains READ if this MUF has the database open without update authority. |
|
OPTIMIZE_OPEN
|
CHAR(1) |
No |
Contains Y or N to indicate the setting of the OPTIMIZE Multi-User startup option for this database ID. |
|
TYPE_ACCESS
|
CHAR(5) |
No |
Contains the type of access allowed for User Requirements Table (URT) opens. OFF indicates NO opens are allowed. UTLTY indicates opens are only allowed by DBUTLTY functions. READ indicates opens are allowed for URTs with UPDATE=NO. WRITE indicates that all opens are allowed. |
|
Copyright © 2014 CA.
All rights reserved.
|
|