Tracking the Archive State

From InterBase
Jump to: navigation, search

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.

RDB$JOURNAL_ARCHIVES Table
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.