Utility Statements › ROLLBACK › ROLLBACK Parameter

ROLLBACK Parameter

FILE

Rolls back one or more files. Recovery by file does not unlock any areas associated with the files.

segment-name

Specifies the segment associated with the file.

file-name

Specifies the name of the file.

AREA

Rolls back and unlocks one or more specified areas.

segment-name

Identifies the segment associated with the area.

area-name

Specifies the name of the area.

SEGMENT

Rolls back and unlocks all areas associated with the specified segments.

segment-name

Specifies the name of the segment.

DMCL

Rolls back all areas defined in the DMCL identified in the SYSIDMS parameter file.

ACTIVE

• If you do not specify a STOP time, before images are appliedonly for transactions that remain open at the end of the journal file. Before images are not applied 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, before images are applied for all transactions until the STOP time is reached, and then processing continues only with open transactions. Before images are not applied 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, before images are appliedfor all transactions in the journal file.
• If you do specify a STOP time, before images are applied for all transactions until the STOP time is reached, and then processing continues only with open transactions.

SEQUENTIAL

Applies before images in the sequence in which they occur starting from the end of the journal file, reading backwards.

SEQUENTIAL is the default.

SORTED

Sorts the before images in the journal file by database key and copies back only the earliest before image for any database key.

All the database keys on a given database page will be copied back together. Each page will be accessed once.

By default, if you do not specify SORTED, the before images will be copied back sequentially.

Note: When recovering VSAM KSDS files, do not use the SORTEDoption. You must use SEQUENTIAL.

VERIFY DATABASE

Verifies the after images in the journal file before applying the before images. If an after image in the journal file does not match the contents of the database, the roll back operation will terminate with an error.

By default, if you do not specify VERIFY, before images are copied back without first verifying the after images.

The optional DATABASE keyword is included for consistency with the ROLLFORWARD utility statement and has no impact on the processing of the VERIFY option.

STOP AT

Directs processing to stop as soon as possible after reaching a specified date and time in the journal file.

By default, processing will stop when the beginning 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 described previously. 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.

HOTBACKUP

Forces ROLLBACK to also restore images for aborted run units.

UTC

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