EXTRACT JOURNAL

The EXTRACT JOURNAL utility conceptually extracts the most recent AFTR image for each dbkey recorded on an archived journal file and writes it to an extract file. The extract file can later be used as input to a ROLLFORWARD command for a "quick" recovery of a database area or file.

When used as part of a regular procedure to extract journal images from archived journal tapes, it allows for a quicker recovery during a critical time frame by doing much of the work during a non-critical time frame. It also speeds up recovery by extracting only the journal images it needs to recover the areas or files selected.

Authorization

DBAWRITE authority is needed for all options.

EXTRACT JOURNAL Syntax

►►─── EXTRACT JOURNAL FOR ─┬─ DMCL ──────────────────────────────┬────────────►
                           │        ┌──────────── , ───────────┐ │
                           ├─ FILE ─▼─ segment-name.file-name ─┴─┤
                           │        ┌──────────── , ───────────┐ │
                           ├─ AREA ─▼─ segment-name.area-name ─┴─┤
                           │           ┌─────── , ──────┐        │
                           └─ SEGMENT ─▼─ segment-name ─┴────────┘

 ►─┬─ COMPLETED ─┬──┬────────────────────┬────────────────────────────────────►
   └─ ALL ───────┘  └─ TO ─┬─ ddname ────┤
                           ├─ file-name ─┤
                           ├─ link-name ─┤
                           └─ SYS002 ◄───┘
 ►─┬──────────────────────────────────────┬───────────────────────────────────►
   └─ VERIFY QUIESCE ──┬───────────┬──────┘
                       ├─ NONE ────┤
                       ├─ LIMITED ─┤
                       └─ FULL ────┘

 ►─┬─────────┬────────────────────────────────────────────────────────────────►
   └─ UTC────┘
 ►──┬─────────────────────────────────────────────────┬───────────────────────►
    └─ START AT ── ' ─┬─ date-time ─┬─ ' ─────────────┘
                      ├─ date ──────┤
                      └─ time ──────┘

 ►──┬──────────────────────────────────────────────────┬──────────────────────►◄
    └─ STOP AT ── ' ─┬─ date-time ─┬─ ' ───────────────┘
                     ├─ date ──────┤
                     └─ time ──────┘

EXTRACT JOURNAL Parameter

DMCL

Specifies that dbkeys for all areas defined in the DMCL specified in the SYSIDMS parameter file will be included in the extract file.

FILE

Specifies to include segment-name.file-name dbkeys in the specified file in the extract file.

AREA

Specifies to include segment-name.area-name dbkeys in the specified area in the extract file.

SEGMENT

Specifies to include dbkeys for all areas defined in the specified segments in the extract file.

COMPLETED

If you do not specify a STOP time, only after images for transactions that have completed by the end of the archive file will be written to the extract file. After images are written to the extract file for incomplete distributed transactions whose state is InDoubt at the end of the journal file (unless a manual recovery control file entry overrides this behavior by specifying BACKOUT for one or more of the transactions).

If you do specify a STOP time, only after images for transactions that have completed by the first checkpoint at or following the stop time will be written to the extract file. After images are written to the extract file for incomplete distributed transactions whose state is InDoubt at the stop time (unless a manual recovery control file entry overrides this behavior by specifying BACKOUT for one or more of the transactions).

ALL

If you do not specify a STOP time, after images for all transactions will be written to the extract file.

If you do specify a STOP time, after images for all transactions will be written to the extract file up to the point at or after the stop time where there are no active transactions. If such a point is not found by the end of the archive file, all after images will be written.

TO

Specifies the external name to be used for the extract file.

ddname

The external z/OS, or CMS name for the extract file.

file-name

The external z/VSE name for the extract file.

SYS002

The default name for all systems.

VERIFY QUIESCE

Specifies the level of quiesce point verification that will be performed.

NONE

Specifies that no quiesce point verification should be done. This is the default if neither VERIFY QUIESCE nor START AT is specified. If START AT is specified, NONE is treated as LIMITED.

LIMITED

Specifies that limited quiesce point verification be performed. This is the default if VERIFY QUIESCE is not specified and START AT is specified.

FULL

Specifies that the strictest form of quiesce point verification be performed. This is the default if VERIFY QUIESCE is specified without indicating the verification level.

START AT

Specifies that the operation should start only after reaching a specified date and time in the journal file. Only images for transactions that begin after the specified start time will be processed. By default, processing starts at the beginning of the journal file.

STOP AT

Specifies that the operation should stop as soon as possible after reaching a specified date and time in the journal file.

By default, processing stops when the end of the journal file is reached.

date

Specifies the date, in one of the following formats:

yyyy-mm-dd
mm/dd/yyyy
dd.mm.yyyy

In these formats, the following rules apply:

yyyy specifies the year. yyyy must be an integer in the range 0001 through 9999. Leading zeros are optional.
mm specifies the month within the year. mm must be an integer in the range 01 through 12. Leading zeros are optional.
dd specifies the day within the month. dd must be an integer in the range 01 through 31. Leading zeros are optional.

The combined values of yyyy, mm, and dd must represent a valid date. For example, 1988-02-29 is a valid date. 1989-02-29 is not.

date-time

Specifies the date and time, where:

The format for specifying the DATE-TIME is:
yyyy-mm-dd-hh.mm.ss.ffffff
The rules for specifying the DATE component of DATE-TIME are the same as for DATE. The rules for specifying the TIME component of DATE-TIME are:
- hh specifies the hour on a 24-hour clock. hh must be an integer in the range 00 through 23. Leading zeros are optional.
- mm specifies the number of minutes past the hour. mm must be an integer in the range 00 through 59. Leading zeros are optional.
- ss specifies the number of seconds past the minute. ss must be an integer in the range 00 through 59. Leading zeros are optional.
- ffffff specifies the number of millionths of a second past the specified second. ffffff is optional; if you include it, it must be an integer in the range 000000 through 999999. The default value is 000000. Trailing zeros are optional.

time

Specifies the time in one of the following formats:

hh.mm.ss
hh:mm:ss

The rules for specifying TIME are the same as those listed for DATE-TIME.

When TIME is specified, the date defaults to the current date.

UTC

Specifies that Start and Stop times are interpreted as UTC times instead of local times.