RDB$JOURNAL ARCHIVES
From InterBase
Go Up to System Tables
RDB$JOURNAL_ARCHIVES stores information about the repository of database and journal archive files.
| Column name | Data type | Length | Description |
|---|---|---|---|
| RDB$ARCHIVE_NAME | VARCHAR
|
1024 | The name of the archived item. |
| RDB$ARCHIVE_TYPE | CHAR
|
1 | The type of the archived item. 'D' indicates a database dump. 'S' indicates a secondary database file of a database dump. 'J' indicates a journal file. |
| RDB$ARCHIVE_LENGTH | INT64
|
8 | Length of the archived item as stored in bytes. |
| RDB$ARCHIVE_SEQUENCE | INTEGER | 4 | Sequence number of archive item. |
| RDB$ARCHIVE_TIMESTAMP | TIMESTAMP | 8 | Timestamp when item was stored in the archive. |
| RDB$DEPENDED_ON_SEQUENCE | INTEGER | 4 | Sequence of archived item that this item depends on. For 'S' archive types, it would be the sequence number of the 'D' primary database dump file. For 'D' archive types, it is the sequence number of the starting journal file for recovering from the archive. |
| RDB$DEPENDED_ON_TIMESTAMP | TIMESTAMP | 8 | As above, but the archive timestamp for the depended on archive item. |