DATABANKS
Records the databanks in the database.
Column name
|
Data type
|
Description
|
DATABANK_SYSID
|
INTEGER
|
System identifier for the databank.
|
DATABANK_SEQNO
|
INTEGER
|
The shadowing sequence number for the databank.
|
DATABANK_FILENO
|
INTEGER
|
The file number of the databank file. |
DATABANK_NAME
|
VARCHAR(128)
|
The name of the databank. |
SHADOW_NAME
|
VARCHAR(128)
|
The shadow name if the databank is a shadow. |
DATABANK_FILENAME
|
VARCHAR(256)
|
The path name for the databank file. |
DATABANK_TYPE
|
CHAR(20)
|
Indicates type of transaction handling:
"LOG" = transaction handling with logging
"TRANS" = transaction handling without logging
"NULL" = transaction handling not used
"WORK" = work databank (SQLDB). |
IS_MASTER
|
CHAR(3)
|
One of:
"NO" = the databank is a shadow
"YES" = the databank is a master. |
IS_ONLINE
|
CHAR(3)
|
One of:
"NO" = the databank is OFFLINE
"YES" = the databank of ONLINE. |
Primary key: DATABANK_SYSID, DATABANK_SEQNO, DATABANK_FILENO
Unique constraint: SHADOW_NAME, DATABANK_FILENO
Unique constraint: DATABANK_FILENAME
Secondary index: DATABANK_NAME, DATABANK_SEQNO
