Utility Statements › ARCHIVE JOURNAL

ARCHIVE JOURNAL

The ARCHIVE JOURNAL utility offloads, to one or more archive journal files, the entries in one or more disk journal files.

The options you can choose depend upon the type of recovery being performed and whether or not the DC/UCF system is active.

Authorization

ARCHIVE JOURNAL Syntax

►►─── ARCHIVE JOURNAL ────────────────────────────────────────────────────────►

 ►─┬────────────────────────┬─────────────────────────────────────────────────►
   └─ BUFFERS buffer-count ─┘

 ►─┬────────────────────────────────┬─────────────────────────────────────────►◄
   ├─ ALL ──────────────────────────┤
   ├─ AUTO ◄────────────────────────┤
   ├─ AUTOALL ──────────────────────┤
   ├─ FULL ─────────────────────────┤
   ├─ READ ─┬─────────────────────┬─┤
   │        └─ journal-file-name ─┘ │
   ├─ REPORT ───────────────────────┤
   └─ RESTART journal-file-name ────┘

ARCHIVE JOURNAL Parameter

BUFFERS

Specifies the number of buffer pages to be used during condense processing.

Condense processing involves copying the before image of unfinished transactions back to the disk journal file after it is offloaded. Condense processing of journal segments takes place when both of the following apply:

• You specify AUTO and
• The DC/UCF system is active or after an abnormal system termination

The buffer is used for storing before images of unfinished transactions before copying the images back to the disk journal file.

The buffer page size is equal to the block size of the disk journal file.

buffer-count

An integer in the range 2 through 32,767. The default is 5.

ALL

Specifies that all non-empty disk journal files are to be offloaded, starting with the file containing the oldest entries.

Note: This option is not allowed while the DC/UCF system is active or after an abnormal system shutdown, unless you are beginning a manual recovery of the entire system.

After offloading the journal files, they are marked as empty.

Before images of unfinished transactions are not rewritten or condensed after offloading the journal files. These before images are needed if you need to recover from an abnormal shutdown.

AUTO

Directs the ARCHIVE JOURNAL utility to select a single file to offload:

• While the DC/UCF system is active or after an abnormal system termination, the oldest full disk journal file is selected.

  After offloading the file, it is condensed.

  After condensing the selected file, a new, empty journal segment is created.

  If no full disk journal file exists, no file is offloaded or condensed.

• After a normal DC/UCF system shutdown, the oldest non-empty disk journal file is selected.

  After offloading the file, it is marked as empty.

AUTOALL

• While the DC/UCF system is active or after an abnormal systemshutdown, the oldest full disk journal file is offloaded. The file is condensed after it is offloaded and a new empty journal segment is created.
• After a normal DC/UCF shutdown, specifies that all non-empty disk journal files are to be offloaded, starting with the file containing the oldest entries.

  After offloading the journal files, they are marked as empty.

FULL

Directs the ARCHIVE JOURNAL utility to offload all full disk journal files associated with the database, starting with the file containing the oldest entries. After offloading each file, it is marked as empty.

Before images of unfinished transactions are not condensed and rewritten. These before images are needed if you need to recover from an abnormal shutdown.

Note: This option is not allowed while the DC/UCF system is active or after an abnormal system shutdown, unless you are beginning a manual recovery of the entire system.

READ

Directs the ARCHIVE JOURNAL utility to offload a single disk journal file without condensing it or marking it as empty afterwards.

If you do not specify a file name, the oldest non-empty disk journal file is offloaded.

journal-file-name

The name of the disk journal file to be read.

REPORT

Displays information about all disk journal files. No archiving or condensing of the journal files is performed.

RESTART

Directs the ARCHIVE JOURNAL utility to restart an archive journal operation that terminated abnormally. If the operation failed:

• While a disk journal file was being offloaded, the offload operation is restarted.
• While a disk journal file was being condensed, the condense operation is restarted.

journal-file-name

The name of the disk journal file being offloaded at the time of the abend.