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
1 – RDB$FLAGS
Represents flags for RDB$DATABASE_ROOT information table.
Bit
Position Description
0 Single file database
1 Open mode
2 Log server mode
3 Snapshots are deferred
4 Global buffers are enabled
5 Carryover locks are enabled
6 Statistics collection is enabled
7 Fast commit is enabled
8 AIJ commit optimization is enabled
9 RUJ is corrupt
10 Database is corrupt
11 Fast incremental backup is enabled
12 Async prefetch is enabled
13 Async batch writes are enabled
14 Lock partitioning is enabled
15 Page transfer via memory
16 Detected async prefetch is enabled
17 Shared memory is system
18 Database has been modified (TSN allocated)
19 Database conversion has been committed
20 Row cache server (RCS) checkpoints to database, by
default
21 RCS checkpoints to backing store files, by default
22 RCS checkpoints marked and unmarked to RDC
23 Global buffers should be in VLM
24 Row cache RUJ global buffers are disabled
25 LogMiner feature is enabled
26 Prestarted transactions are enabled
27 VMS Galaxy shared memory is enabled