Displays information about the database journal files.

    Column Name                 Data Type      Description

    RDB$LAST_BACKUP             date vms       Date of last AIJ
                                               backup
    RDB$STATUS                  integer        AIJ file is
                                               inaccessible
    RDB$ALLOCATION              integer        Allocation
    RDB$EXTENT                  integer        Extent
    RDB$FLAGS                   integer        Flags
    RDB$JOURNAL_NAME            char(31)       Journal name
    RDB$LAST_BACKUP_SEQUENCE    integer        Last version number
                                               backed up
    RDB$LAST_ACTIVATED          date vms       Date last activated
    RDB$BACKUP_EDIT_STRING      varchar(255)   Backup editname file
    RDB$DEFAULT_FILENAME        char(255)      Default journal name
    RDB$FILENAME                char(255)      Journal name
    RDB$BACKUP_FILENAME         char(255)      Backup file name
    RDB$SEQUENCE_NUMBER         integer        Current AIJ sequence
                                               number
    RDB$STATE                   char(31)       State ("Current" or
                                               "Latent")

1  –  RDB$FLAGS

    Represents flags for RDB$JOURNALS information table.

    Bit
    Position   Description

    0          Initialization in progress
    1          Backup in progress
    2          AIJ file has been modified
    3          AIJ restored from existing file
    4          Hard data loss resulted from fail over
    5          Soft data loss resulted from fail over
    6          New version of journal created
    7          Journal has been overwritten
    8          Backup failed prematurely
    9          Journal created due to switch-over suspension
    10         AIJ file block has been assigned
    11         Journal created for recovery synchronization