The DB2 Interface › JARSDB22: Sample Report

JARSDB22: Sample Report

JARSDB22 is a sample report showing how you can use the CAWGJRD2 glossary and your DB2 input data to create CA JARS reports. A sample of the output from JARSDB22 is shown below

                                              DB2 USAGE BY USER (AUTHORIZATION) ID                        23 MAR 1994 PAGE    1

                         CONNECT                      CPU         SRB
          CONNECT            TOD       USER          TIME        TIME           BP0           BP1           BP2          BP32
             DATE       HH.MM.SS       ID          SS.SSS      SS.SSS          READ          READ          READ          READ
        -----------     --------     --------     -------     -------     ---------     ---------     ---------     ---------

        09 MAR 1994     11.57.43     JAKSU01         .320        .040             0             0             0             0
        09 MAR 1994     12.13.32     JAKSU01         .540        .040             0             0             0             0
        09 MAR 1994     12.21.12     JAKSU01         .300        .040             0             0             0             0
        09 MAR 1994     12.21.51     JAKSU01         .320        .030             0             0             0             0
        09 MAR 1994     12.22.55     JAKSU01         .320        .040             5             0             0             0
        10 MAR 1994     08.20.27     JAKSU01         .330        .030             1             0             0             0
        10 MAR 1994     08.59.03     JAKSU01         .310        .030             0             0             0             0
        10 MAR 1994     08.59.32     JAKSU01         .060        .010             0             0             0             0
        10 MAR 1994     09.19.22     JAKSU01         .060                         0             0             0             0
                                                  -------     -------     ---------     ---------     ---------     ---------

 USER ID TOTAL                       JAKSU01        2.560        .260             6             0             0             0

        01 FEB 1994     10.55.48     KOLFI01         .870        .040             0             0             0             0
        01 FEB 1994     10.56.03     KOLFI01         .880        .020             0             0             0             0
               .
               .
               .
                                             DB2 USAGE BY USER (AUTHORIZATION) ID                        23 MAR 1994 PAGE    2

                         CONNECT                      CPU         SRB
          CONNECT            TOD       USER          TIME        TIME           BP0           BP1           BP2          BP32
             DATE       HH.MM.SS       ID          SS.SSS      SS.SSS          READ          READ          READ          READ
        -----------     --------     --------     -------     -------     ---------     ---------     ---------     ---------
       *CONTINUED*
        10 MAR 1994     10.37.26     KOLFI01         .120                         0             0             0             0
        10 MAR 1994     10.37.35     KOLFI01        7.210        .090           120             0             0             0
        10 MAR 1994     10.41.59     KOLFI01        5.910        .100           135             0             0             0
                                                  -------     -------     ---------     ---------     ---------     ---------

 USER ID TOTAL                       KOLFI01       97.760       1.680         2,111             0             0             0

        01 FEB 1994     10.47.12     MCFRED          .010                         0             0             0             0
                .
                .
                .
        10 MAR 1994     09.10.25     MCFRED          .100                         3             0             0             0
        10 MAR 1994     09.10.35     MCFRED          .100                         3             0             0             0
        10 MAR 1994     09.10.46     MCFRED          .100                         3             0             0             0
        10 MAR 1994     10.39.44     MCFRED          .100                         3             0             0             0
        10 MAR 1994     10.39.50     MCFRED          .100                         3             0             0             0
        10 MAR 1994     10.39.54     MCFRED          .100                         3             0             0             0
                                                  -------     -------     ---------     ---------     ---------     ---------

 USER ID TOTAL                       MCFRED        14.590        .020           436             0             0             0

                                                  -------     -------     ---------     ---------     ---------     ---------

   GRAND TOTAL                                    375.680       9.290         4,914             0             0             0