FLASHBACK LIST Command-Generate Transaction Report

Commands › FLASHBACK LIST Command-Generate Transaction Report

FLASHBACK LIST Command-Generate Transaction Report

The FLASHBACK LIST command:

Generates detailed reports on transactions
Produces one line of output per transaction

You can change the number of columns per line by specifying variables with the FLASHBACK LIST command.

Transactions are listed in chronological order of ending time. You cannot sort flashback reports. You can run flashback reports against the flashback file, the archive file, or a backup of the archive file (a log file).

Important! Each flashback report must be run as a single report in a separate run. In other words, you cannot specify another primary report command in a job stream with the FLASHBACK LIST command. For example, TAB or PLOT or another FLASHBACK LIST command.

Note: Only a brief description of the FLASHBACK LIST command is given here. For a more detailed description, see the chapter “Historical Reports.”

This command has the following syntax:

FLASHBACK LIST [columns] [idoption(identifiers)]
 [variable [options][HDR1(text)] [HDR2(text)] [AND,
 variable [options] [HDR1(text)] [HDR2(text)]] [AND,...]]

columns

Defines one or more of the following, in any order, to indicate the first columns to appear in the report. Not specifying any of these columns organizes the resulting report by region ID and time.

DATETIME - Creates columns for the date and time of the record.

DATE - Creates a column for the date of the record.

TIME - Creates a column for the time of the record.

DAY - Creates a column for the day of the record (MONDAY, TUESDAY, and so forth).

JOBNAME - Creates a column for the CICS job names.

You are only able to enter one of the following: DATETIME, DATE, TIME, and DAY. The width of the output page limits the number of columns that can appear in a report. You can use one of these operands only if you specify the variables to include in your report and limit their number. The number of variables you can specify depends upon the width of the column for each.

idoption(identifiers)

Includes all the resources (or only resources specified by identifiers) for an ID option. You can specify multiple ID options.

variable

Indicates any Report Writer variable. If you specify a variable, also specify at least one ID option.

options

Specifies any valid variable options or ID options. Each ID option you specify must include at least one identifier.

HDR1(text)

Overrides the default top heading for a column. Replace text with the new column heading. To remove the header, replace text with a null string, for example, HDR1( ).

HDR2(text)

Overrides the default bottom heading for a column. Replace text with the new column heading. To remove the header, replace text with a null string, for example, HDR2( ).

AND,

Signals that another variable is specified. The comma after AND lets you continue to the next line.

Note: The FLASHBACK LIST command can generate enormous amounts of output when run against a large input file. To avoid problems, use either the FROM and TO commands, the COUNT command, or the SELECT command to limit the output.

Example: FLASHBACK LIST Command

The following FLASHBACK LIST command is specified with the DATETIME operand. The COUNT command, specified with the SELECTED operand, limits the report to 15 transactions meeting either the FROM or the TO criterion specified.

FLASHBACK LIST DATETIME TRANID TRAN LIFE AND,
                         TRAN I/OTIME    AND,
                         TRAN WAIT       AND,
                         TRAN SUSP       AND,
                         TERM I/OTIME    AND,
                         TRAN CPU
  FROM 12/06/10 21:00:00
  TO   12/06/10 22:00:00
  COUNT 15 SELECTED
END
RUN