Tracking the Archive State
Go Up to Managing Archive Size
To track the state of the archive, use the RDB$JOURNAL_ARCHIVES
system table. The gbak and gfix commands use this system table to decide which archive items are targets for the command.
The following table describes column and data type information for RDB$JOURNAL_ARCHIVES
.
Column Name | Data Type | Length | Description |
---|---|---|---|
RDB$ARCHIVE_NAME |
CHAR |
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 archived 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 no. of the 'D' primary database dump file. For 'D' archive types, it is the sequence no. of the starting journal file for recovering from the archive. |
RDB$DEPENDED_ON_TIMESTAMP |
TIMESTAMP |
8 |
As above, but the archive timestamp for the archived item that this item depends on. |