Historical Reports › FLASHBACK LIST Command › Create Report with Specified Columns

Create Report with Specified Columns

To produce a flashback report with different columns than the default report, specify one or more variables with the FLASHBACK LIST command. A column is created in the report for each variable you specify.

The following commands produce a report that displays all the components comprising transaction lifetime. TRAN EXPC and TRAN CPU are not true components of transaction lifetime, because the times found in these variables are accounted for in other variables.

FLASHBACK LIST TIME TRANID TRAN NUM     AND,
                           TRAN LIFE    AND,
                           TRAN USER    AND,
                           TRAN CICS    AND,
                           TRAN I/OTIME AND,
                           TRAN WAIT    AND,
                           TRAN SUSP    AND,
                           TRAN WTR     AND,
                           TRAN RSCS    AND,
                           TRAN EXPC    AND,
                           TERM I/OTIME AND,
                           TRAN CPU
  COUNT 20
END
RUN

A report like the following is generated:

           TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN     TRAN
  TIME      ID     NUMBER    LIFE     USER     CICS      I/O     WAIT     SUSP      WTR     RSCS     EXPC     TMIO      CPU
-------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- --------
21.16.58 CSDA         19    0.016    0.000    0.000    0.000    0.000    0.000    0.001    0.000    0.001    0.000    0.011
21.21.52 CIRB         20    13.30    0.000    0.000    0.000    1.375    0.000    0.002    5.519    0.004    1.521    1.175
21.22.41 TCP           0    911.9    0.000    0.000    0.381    901.3    0.000    2.173    3.597    0.325    0.000    2.110
21.24.20 TCP           0    912.3    0.000    0.000    0.000    906.8    0.000    1.372    1.900    0.233    0.000    1.051
21.22.42 KCP           0    912.3    0.000    0.000    0.000    0.000    0.000    895.7    0.000    0.000    0.000    1.878
21.23.06 JJJ           0    937.1    0.000    0.000    0.000    0.418    934.7    0.001    0.000    0.001    0.000    1.942
21.23.06 CATD         51    6.529    0.000    0.000    0.000    0.124    0.000    0.009    2.579    0.003    0.000    0.326
21.23.07 CSNE         52    0.081    0.000    0.000    0.000    0.000    0.000    0.009    0.000    0.000    0.000    0.068
21.23.08 CSGM         53    0.264    0.000    0.000    0.000    0.000    0.000    0.002    0.139    0.001    0.017    0.010
21.23.15 VGBR         55    0.332    0.000    0.000    0.000    0.000    0.000    0.080    0.221    0.002    0.000    0.023
21.23.15 CSNE         56    0.013    0.000    0.000    0.000    0.000    0.000    0.002    0.000    0.000    0.000    0.002
-------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- --------
21.23.15             306    335.8    0.000    0.000    0.035    164.5    84.97    81.76    1.269    0.052    0.140    0.782
-------- -------- -------- -------- -------- -------- -------- -------- -------- -------------- -- -------- -------- --------