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")
Additional Information:
explode
extract