VMS Help  —  SQL72  Information Tables, RDB$DATABASE_ROOT
    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
RDB$FLAGS
Close Help