Utility Statements › PRINT JOURNAL › PRINT JOURNAL Parameter

PRINT JOURNAL Parameter

START AT

Directs the PRINT JOURNAL utility to report only on checkpoints written for transactions that started on or after the indicated date and time.

By default, if you do not specify a start date or date and time, processing begins with the first checkpoint written in the archive journal file.

STOP AT

Directs the PRINT JOURNAL utility to report on checkpoints written only for transactions that started on or before the indicated date and time.

By default, if you do not specify a stop date or date and time, processing ends with the last checkpoint written to the archive journal file.

date

Specifies the date, in one of the following formats:

• yyyy-mm-dd
• mm/dd/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 and time are:

  yyyy-mm-dd-hh.mm.ss.ffffff

• The rules for specifying the date component of DATE-TIME are the same as for the DATE option described previously. Rules for specifying the TIME component 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 the following format:

• hh:mm:ss

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

When specifying time, the date defaults to the current date.

REPORT

Specifies the amount of detail that is to appear on the report.

FULL

Specifies that all details are to be reported. For every transaction, this includes checkpoints, database statistics, and area usage. All details of a distributed transaction record are reported. This includes local transaction ids with program names, external transaction ids, and resource manager interests. Additionally, transactions active at the end of the process are listed and the time of the last global quiesce point is identified. FULL is the default if no REPORT option is specified.

TERSE

Indicates that only transaction checkpoints and summary information is produced. For distributed transaction records: external transaction ids and resource manager interests are not included in the report.

SUMMARY

Indicates that only final summary information is produced.

UTC

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