Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX