RDB$JOURNAL ARCHIVES

From InterBase

Go Up to System Tables


RDB$JOURNAL_ARCHIVES stores information about the repository of database and journal archive files.

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