Displays information about the default journal information.
Data
Column Name Type Description
RDB$CONDITION integer AIJ status
RDB$DEFAULT_ALLOCATION integer Default allocation in
blocks
RDB$DEFAULT_EXTENT integer Default extension in blocks
RDB$CURRENT_BACKUP_ integer Backup sequence number
SEQUENCE
RDB$CURR_RECOVERY_ integer Recovery sequence number
SEQUENCE
RDB$DATABASE_BACKUP_ integer Database backup sequence
SEQUENCE number
RDB$ALLOCATION integer Number of allocated AIJ
file blocks
RDB$SHUTDOWN_TIME_MIN integer Shutdown time in minutes
RDB$OPERATOR_CLASSES integer Operator class
RDB$FLAGS integer Flags
RDB$DEFAULT_BACKUP_ char(255) Default backup file name
FILENAME
RDB$CACHE_FILENAME char(255) Cache file name
RDB$STANDBY_FILENAME char(255) Standby database file name
RDB$SERVER_NAME char(31) Server name
RDB$BACKUP_EDIT_STRING varchar(25Backup editname file
RDB$REMOTE_NODE_NAME char(31) Remote node name
RDB$CUR_ACTIVE_AIJ integer Current active AIJ journal
index
RDB$MASTER_FILENAME char(255) When database replication
is active on the standby
database, this field
contains the file name
of the master database
1 – RDB$FLAGS
Represents flags for RDB$DATABASE_JOURNAL information table.
Bit
Position Description
0 Journaling is enabled
1 Overwrite is enabled
2 Backup mode
3 New journal version
4 ABS uses quiet-point AIJ backup
5 Replicated as master
6 Replicated as standby
7 Master replication database
8 Database replication online
9 Hot Standby quiet-point
10 Hot Standby is enabled
11 Database changes made when AIJ disabled
12 One or more journals overwritten
13 Hard data loss resulted from fail over
14 Full quiet-point AIJ backup required