E.4 MON$DATABASE

MON$DATABASE displays the header information from the database the current user is connected to.

Column Name Data Type Description
MON$DATABASE_NAME VARCHAR(255) The file name and full path of the primary database file, or the database alias
MON$PAGE_SIZE SMALLINT Database page size in bytes
MON$ODS_MAJOR SMALLINT Major ODS version, e.g., 11
MON$ODS_MINOR SMALLINT Minor ODS version, e.g., 2
MON$OLDEST_TRANSACTION BIGINT The number of the oldest [interesting] transaction (OIT)
MON$OLDEST_ACTIVE BIGINT The number of the oldest active transaction (OAT)
MON$OLDEST_SNAPSHOT BIGINT The number of the transaction that was active at the moment when the OAT was started — oldest snapshot transaction (OST)
MON$NEXT_TRANSACTION BIGINT The number of the next transaction, as it stood when the monitoring snapshot was taken
MON$PAGE_BUFFERS INTEGER The number of pages allocated in RAM for the database page cache
MON$SQL_DIALECT SMALLINT Database SQL Dialect: 1 or 3
MON$SHUTDOWN_MODE SMALLINT The current shutdown state of the database: 0 - the database is online 1 - multi-user shutdown 2 - single-user shutdown 3 - full shutdown
MON$SWEEP_INTERVAL INTEGER Sweep interval
MON$READ_ONLY SMALLINT Flag indicating whether the database is read-only (value 1) or read-write (value 0)
MON$FORCED_WRITES SMALLINT Indicates whether the write mode of the database is set for synchronous write (forced writes ON, value is 1) or asynchronous write (forced writes OFF, value is 0)
MON$RESERVE_SPACE SMALLINT The flag indicating reserve_space (value 1) or use_all_space (value 0) for filling database pages
MON$CREATION_DATE TIMESTAMP The date and time when the database was created or was last restored
MON$PAGES BIGINT The number of pages allocated for the database on an external device
MON$STAT_ID INTEGER Statistics identifier
MON$BACKUP_STATE SMALLINT Current physical backup (nBackup) state: 0 - normal 1 - stalled 2 - merge
MON$CRYPT_PAGE BIGINT Number of encrypted pages
MON$OWNER CHAR(63) Username of the database owner
MON$SEC_DATABASE CHAR(7) Displays what type of security database is used: Default - default security database, i.e. security4.fdb Self - current database is used as security database Other - another database is used as security database (not itself or security4.fdb)
MON$CRYPT_STATE SMALLINT Current state of database encryption 0 - not encrypted 1 - encrypted 2 - decryption in progress 3 - encryption in progress
MON$GUID CHAR(38) Database GUID (persistent until restore/fixup)
MON$FILE_ID VARCHAR(255) Unique ID of the database file at the filesystem level
MON$NEXT_ATTACHMENT BIGINT Current value of the next attachment ID counter
MON$NEXT_STATEMENT BIGINT Current value of the next statement ID counter
MON$REPLICA_MODE SMALLINT Database replica mode 0 - not a replica 1 - read-only replica 2 - read-write replica