Displays information about the database root.
Data
Column Name Type Description
RDB$CREATED date vms Date of database
creation
RDB$LAST_FULL_BACKUP_TIME date vms Date of last complete
full backup
RDB$MAJOR_VERSION integer Major software version
RDB$MINOR_VERSION integer Minor software version
RDB$PRIOR_MAJOR_VERSION integer Major software version
for database converted
with /nocommit
RDB$PRIOR_MINOR_VERSION integer Minor software version
for database converted
with /nocommit
RDB$FLAGS integer Flags
RDB$MAX_USERS integer Number of users
RDB$MAX_CLUSTER_NODES integer Number of cluster
nodes
RDB$DEFAULT_NUM_OF_BUFFERS integer Number of buffers
RDB$MAX_RECOVERY_BUFFERS integer Number of recover
buffers
RDB$BUFFER_SIZE integer Buffer size
RDB$GLOBAL_BUFFER_COUNT integer Number of global
buffers
RDB$ALG_COUNT integer Adjustable lock
granularity count
RDB$LOCK_TIMEOUT_INTERVAL integer Lock timeout interval
in seconds
RDB$CHECKPOINT_INTERVAL_BLKS integer Checkpoint block
interval
RDB$CHECKPOINT_TIMED_SECONDS integer Checkpoint time
interval
RDB$TRANSACTION_INTERVAL integer Commit transaction
interval
RDB$CLOSE_MODE integer Close mode
RDB$CLOSE_INTERVAL integer Close interval
RDB$ASYNC_PREFETCH_DEPTH integer Async prefetch depth
RDB$D_ASYNC_PREFETCH_DEPTH integer Detected async
prefetch depth
RDB$D_ASYNC_PREFETCH_THRESHOLD integer Detected async
prefetch threshold
RDB$CLEAN_BUFFER_COUNT integer Clean buffer count
RDB$MAX_BUFFER_COUNT integer Maximum buffer count
RDB$MIN_PAGE_SIZE_BLOCKS integer Minimum area page
block count
RDB$MAX_PAGE_SIZE_BLOCKS integer Maximum area page
block count
RDB$TRANSACTION_MODE_FLAGS integer Transaction mode
RDB$ALG_FACTOR_0 integer Adjustable locking
granularity factor 0
RDB$ALG_FACTOR_1 integer Adjustable locking
granularity factor 1
RDB$ALG_FACTOR_2 integer Adjustable locking
granularity factor 2
RDB$ALG_FACTOR_3 integer Adjustable locking
granularity factor 3
RDB$ALG_FACTOR_4 integer Adjustable locking
granularity factor 4
RDB$ALG_FACTOR_5 integer Adjustable locking
granularity factor 5
RDB$ALG_FACTOR_6 integer Adjustable locking
granularity factor 6
RDB$ALG_FACTOR_7 integer Adjustable locking
granularity factor 7
RDB$AUDIT_FILENAME char(255) Audit journal file
name
RDB$ROOT_FILENAME char(255) Database root file
name
RDB$RUJ_LOCATION char(255) Default recovery-unit
journal file name
RDB$CACHE_LOCATION char(255) Default
device/directory
specification for
record cache files
RDB$MAX_PAGES_IN_BUFFER integer Maximum number of
pages in a buffer
RDB$RCS_SWEEP_INTERVAL integer Row cache server (RCS)
sweep interval (in
seconds)
RDB$RCS_CKPT_TIME integer Time interval to force
row cache server (RCS)
to checkpoint. This
field contains the
number of seconds
that pass before RCS
is forced to perform
another checkpoint
RDB$LAST_FULL_RESTORE date vms Date of last complete
full restore
RDB$AIJ_ACTIVATION_ID bigint AIJ journaling
activation identifier
RDB$RCVR_ACTIVATION_ID bigint RCVR journaling
activation identifier
RDB$OPER_CLASS integer Operator notification
classes
RDB$PRESTART_TXN_TIMEOUT integer Seconds until
prestarted transaction
is abandoned. Zero
means no abandon timer
RDB$DB_REPLICATED integer AIJ log roll forward
server started
Additional Information:
explode
extract