RDB$JOURNAL ARCHIVES
Go Up to System Tables
RDB$JOURNAL_ARCHIVES stores information about the repository of database and journal archive files.
| Column name | Datatype | Length | Description |
|---|---|---|---|
|
RDB$ARCHIVE_ NAME |
|
1024 |
The name of the archived item. |
|
RDB$ARCHIVE_ TYPE |
|
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 |
|
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. |