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