Previous Topic: ADABAS Interface Reports

Next Topic: EXTDATA Reports


CA JARS Reports

Three CA JARS sample reports are provided with the ADABAS Interface.

  1. ADABAS Utilization Report
  2. ADABAS Job Charge Detail Report
  3. ADABAS Job Charge Summary Report

Samples of each report and the system and report control statements required to generate them are shown next.

ADABAS Utilization report

The sample ADABAS Utilization Report was obtained by executing a modified version of member ADAUTLR in the source library. The following system control statements were used.

System Control Statements

1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80
 CONFIG  OTHE01F
 SELECT       1                                   0

These Report Writer control statements were used to produce the report.

Report Control Statements

1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80
 CONFIG  OTHE01F
 SELECT       1                                   0
0HEADER     A D A B A S    U T I L I Z A T I O N
0SORT    01608A2109908A2110708A1
0DISPLAY QA0021561401651661061121131F4
0DESCRIPT3****1381
0DESCRIPT2****0881
0DESCRIPT1****0181
0EDIT    06 L12 L13 HF4 D
0TITLE   02       TERM CM FILE JOBNAME ID  CD  NBR
1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80

The sample report (two pages) follows.

ADABAS Utilization Report (page 1 of 2):

A D A B A S U T I L I Z A T I O N BEGIN DATE - 07/21/94 RUN DATE - 08/15/94 END DATE - 07/21/94 PAGE 1 TERM CM FILE CMD TOTAL ELAPSED ESTIMATED MIN STRT MIN STRT MAX END USER ACCOUNT JOBNAME ID CD NBR COUNT I/O COUNT TIME CPU TIME DATE TIME TIME CODE ADABASX2 01541 A1-00005 5 0 00:00:01 00:00:01 87/07/21 09:54:29 09:54:47 ADABAS - USER 1 A4-00005 79 14 00:01:18 00:00:22 87/07/21 09:54:28 09:54:54 ADABAS - USER 1 CL-00005 1 33 00:00:44 00:00:03 87/07/21 09:54:55 09:54:56 ADABAS - USER 1 ET-00005 20 19 00:01:34 00:00:02 87/07/21 09:54:28 09:54:55 ADABAS - USER 1 HI-00005 9 0 00:00:00 00:00:00 87/07/21 09:54:34 09:54:51 ADABAS - USER 1 L3-00005 1 0 00:00:54 00:00:00 87/07/21 09:54:27 09:54:28 ADABAS - USER 1 L4-00005 138 0 00:00:10 00:00:15 87/07/21 09:54:29 09:54:55 ADABAS - USER 1 N1-00005 18 3 00:00:37 00:00:07 87/07/21 09:54:28 09:54:54 ADABAS - USER 1 OP-00005 1 0 00:00:16 00:00:00 87/07/21 09:54:27 09:54:27 ADABAS - USER 1 RC-00005 85 0 00:00:01 00:00:02 87/07/21 09:54:29 09:54:54 ADABAS - USER 1 RI-00005 64 0 00:00:01 00:00:02 87/07/21 09:54:29 09:54:54 ADABAS - USER 1 S2-00005 23 69 00:02:01 00:00:34 87/07/21 09:54:30 09:54:54 ADABAS - USER 1 S4-00005 160 0 00:01:12 00:00:08 87/07/21 09:54:28 09:54:55 ADABAS - USER 1 01541 604 138 00:08:48 00:01:36 87/07/21 09:54:27 09:54:56 ADABAS - USER 1 02923 A4-00005 9 2 00:00:14 00:00:03 87/07/21 09:53:33 09:53:37 ADABAS-CATCH ALL CL-00005 1 43 00:01:18 00:00:03 87/07/21 09:53:38 09:53:39 ADABAS-CATCH ALL ET-00005 2 2 00:00:07 00:00:00 87/07/21 09:53:37 09:53:38 ADABAS-CATCH ALL L4-00005 14 0 00:00:01 00:00:02 87/07/21 09:53:35 09:53:37 ADABAS-CATCH ALL N1-00005 1 0 00:00:00 00:00:00 87/07/21 09:53:37 09:53:37 ADABAS-CATCH ALL RC-00005 8 0 00:00:00 00:00:00 87/07/21 09:53:35 09:53:37 ADABAS-CATCH AL RI-00005 5 0 00:00:00 00:00:00 87/07/21 09:53:35 09:53:37 ADABAS-CATCH ALL S2-00005 1 3 00:00:04 00:00:02 87/07/21 09:53:37 09:53:37 ADABAS-CATCH ALL S4-00005 17 0 00:00:05 00:00:01 87/07/21 09:53:35 09:53:38 ADABAS-CATCH ALL 02923 58 50 00:01:50 00:00:11 87/07/21 09:53:33 09:53:39 ADABAS-CATCH ALL 17810 A1-00005 2 0 00:00:00 00:00:00 87/07/21 09:53:46 09:53:46 ADABAS - USER 2 A4-00005 49 7 00:00:34 00:00:14 87/07/21 09:53:46 09:54:08 ADABAS - USER 2 CL-00005 1 32 00:00:55 00:00:03 87/07/21 09:54:10 09:54:11 ADABAS - USER 2 ET-00005 16 15 00:01:23 00:00:02 87/07/21 09:53:46 09:54:10 ADABAS - USER 2 L3-00005 1 0 00:00:00 00:00:00 87/07/21 09:53:46 09:53:46 ADABAS - USER 2 L4-00005 92 0 00:00:09 00:00:10 87/07/21 09:53:47 09:54:08 ADABAS - USER 2 N1-00005 14 4 00:00:21 00:00:05 87/07/21 09:53:46 09:54:07 ADABAS - USER 2 OP-00005 1 0 00:00:00 00:00:00 87/07/21 09:53:46 09:53:46 ADABAS - USER 2 RC-00005 65 0 00:00:01 00:00:02 87/07/21 09:53:47 09:54:07 ADABAS - USER 2 RI-00005 40 0 00:00:01 00:00:01 87/07/21 09:53:47 09:54:07 ADABAS - USER 2 S2-00005 13 39 00:01:37 00:00:19 87/07/21 09:53:47 09:54:07 ADABAS - USER 2 S4-00005 122 0 00:00:42 00:00:06 87/07/21 09:53:46 09:54:10 ADABAS - USER 2 17810 416 97 00:05:43 00:01:02 87/07/21 09:53:46 09:54:11 ADABAS - USER 2 ADABASX2 1,078 285 00:16:21 00:02:50 87/07/21 09:53:33 09:54:56 ADABAS - USER 2

ADABAS Utilization Report (page 2 of 2):

                                   A D A B A S    U T I L I Z A T I O N  BEGIN DATE - 07/21/94                                                                RUN DATE - 08/15/94  END DATE   - 07/21/94                                                                           PAGE   2         TERM CM FILE     CMD      TOTAL    ELAPSED  ESTIMATED MIN STRT MIN STRT  MAX END     USER ACCOUNT  JOBNAME ID  CD  NBR   COUNT  I/O COUNT       TIME  CPU  TIME     DATE     TIME     TIME             CODE  CICS15X         03085                -00000      1          0   00:00:12   00:00:00 87/07/21 14:02:01 14:02:01 ALL  CICS  USERS              BT-00004      1          0   00:00:00   00:00:00 87/07/21 14:02:06 14:02:06 ALL  CICS  USERS              ET-00000      2          1   00:00:04   00:00:00 87/07/21 14:02:15 14:02:26 ALL  CICS  USERS              L2-00001  1,004         48   00:04:37   00:00:45 87/07/21 14:05:55 14:06:07 ALL  CICS  USERS              L2-00002    380         15   00:02:06   00:00:17 87/07/21 14:06:23 14:06:27 ALL  CICS  USERS              L3-00004     52         30   00:07:37   00:00:03 87/07/21 14:02:03 14:06:23 ALL  CICS  USERS              L9-00004      3          1   00:00:18   00:00:00 87/07/21 14:02:16 14:02:26 ALL  CICS  USERS              N1-00004      1          0   00:00:08   00:00:00 87/07/21 14:02:15 14:02:15 ALL  CICS  USERS              OP-00004      1          9   00:01:06   00:00:01 87/07/21 14:02:15 14:02:16 ALL  CICS  USERS              RC-00000      4          0   00:00:00   00:00:00 87/07/21 14:02:15 14:06:07 ALL  CICS  USERS              RC-00004     17          0   00:00:01   00:00:00 87/07/21 14:02:05 14:06:23 ALL  CICS  USERS              S1-00004      6          9   00:01:39   00:00:02 87/07/21 14:02:14 14:06:23 ALL  CICS  USERS         03085          1,472        113   00:17:48   00:01:09 87/07/21 14:02:01 14:06:27 ALL  CICS  USERS  CICS15X               1,472        113   00:17:48   00:01:09 87/07/21 14:02:01 14:06:27 ALL  CICS  USERS  KWL1PR05              BT-00004      3          0   00:00:00   00:00:00 87/07/21 14:03:58 14:06:04 ALL OTHER USERS              CL-00004      3          0   00:00:00   00:00:00 87/07/21 14:03:59 14:06:05 ALL OTHER USERS              L3-00004      9          2   00:04:20   00:00:00 87/07/21 14:03:56 14:06:04 ALL OTHER USERS              OP-00004      3          2   00:03:28   00:00:00 87/07/21 14:03:55 14:06:03 ALL OTHER USERS              RC-00000      3          0   00:00:00   00:00:00 87/07/21 14:03:59 14:06:05 ALL OTHER USERS              RC-00004      6          0   00:00:00   00:00:00 87/07/21 14:03:57 14:06:04 ALL OTHER USERS              S1-00004      3          5   00:00:40   00:00:01 87/07/21 14:03:58 14:06:05 ALL OTHER USERS                           30          9   00:08:29   00:00:02 87/07/21 14:03:55 14:06:05 ALL OTHER USERS  KWL1PR05                 30          9   00:08:29   00:00:02 87/07/21 14:03:55 14:06:05 ALL OTHER USERS                        2,580        407   00:42:37   00:04:00 87/07/21 09:53:33 14:06:27 ALL OTHER USERS  CAJS003I NORMAL END OF PROCESSING

ADABAS Job Charge Detail Report

The sample ADABAS Job Charge Detail Report, shown on the next page was obtained by executing a modified version of member ADADETR in the source library. The following system control statements were used.

System Control Statements

1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80
 CONFIG  OTHE01F
 SELECT       1                                   0

These Report Writer control statements were used to produce the report.

Report Control Statements

1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80
 CONFIG  OTHE01F
 SELECT       1                                   0
0HEADER     A D A B A S    J O B    C H A R G E    D E T A I L
0SORT    01608A2109908A2110708A1
0DISPLAY QA002156166144133134139140145146142
0RATE     1000500       100      001001         001
0DESCRIPT3****1381
0DESCRIPT2****0881
0DESCRIPT1****0181
0TITLE   02       TERM CM FILE JOBNAME ID  CD  NBR
1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80

The sample report consists of two pages.

ADABAS Job Charge Detail Report (1 of 2):

                                        A D A B A S    J O B    C H A R G E    D E T A I L  BEGIN DATE - 07/21/94                                                                                         RUN DATE - 08/15/94  END DATE   - 07/21/94                                                                                                    PAGE   1         TERM CM FILE     CMD  ESTIMATED     PROCESS ASSOCIATOR       WORK       DATA      TOTAL         I/O        TOTAL  PERCENT  JOBNAME ID  CD  NBR   COUNT  CPU  TIME      CHARGE  I/O COUNT  I/O COUNT  I/O COUNT  I/O COUNT      CHARGE       CHARGE    TOTAL  ADABASX2         01541              A1-00005      5   00:00:01        $.29          0          0          0          0        $.00         $.29     .235              A4-00005     79   00:00:22       $6.16          6          8          0         14       $1.95        $8.11    6.572              CL-00005      1   00:00:03        $.72         30          2          1         33       $4.59        $5.31    4.303              ET-00005     20   00:00:02        $.59          0         19          0         19       $2.64        $3.23    2.617              HI-00005      9   00:00:00        $.06          0          0          0          0        $.00         $.06     .049              L3-00005      1   00:00:00        $.02          0          0          0          0        $.00         $.02     .016              L4-00005    138   00:00:15       $4.22          0          0          0          0        $.00        $4.22    3.420              N1-00005     18   00:00:07       $1.87          3          0          0          3        $.42        $2.29    1.856              OP-00005      1   00:00:00        $.01          0          0          0          0        $.00         $.01     .008              RC-00005     85   00:00:02        $.57          0          0          0          0        $.00         $.57     .462              RI-00005     64   00:00:02        $.43          0          0          0          0        $.00         $.43     .348              S2-00005     23   00:00:34       $9.55          0         69          0         69       $9.59       $19.14   15.509              S4-00005    160   00:00:08       $2.31          0          0          0          0        $.00        $2.31    1.872         01541            604   00:01:36      $26.80         39         98          1        138      $19.19       $45.99   37.267         02923              A4-00005      9   00:00:03        $.77          0          2          0          2        $.28        $1.05     .851              CL-00005      1   00:00:03        $.94         40          2          1         43       $5.97        $6.91    5.599              ET-00005      2   00:00:00        $.06          0          2          0          2        $.28         $.34     .276              L4-00005     14   00:00:02        $.43          0          0          0          0        $.00         $.43     .348              N1-00005      1   00:00:00        $.10          0          0          0          0        $.00         $.10     .081              RC-00005      8   00:00:00        $.05          0          0          0          0        $.00         $.05     .041              RI-00005      5   00:00:00        $.03          0          0          0          0        $.00         $.03     .024              S2-00005      1   00:00:02        $.42          0          3          0          3        $.42         $.84     .681              S4-00005     17   00:00:01        $.25          0          0          0          0        $.00         $.25     .203         02923             58   00:00:11       $3.05         40          9          1         50       $6.95       $10.00    8.104         17810              A1-00005      2   00:00:00        $.12          0          0          0          0        $.00         $.12     .097              A4-00005     49   00:00:14       $3.88          2          5          0          7        $.97        $4.85    3.930              CL-00005      1   00:00:03        $.70         28          2          2         32       $4.45        $5.15    4.173              ET-00005     16   00:00:02        $.47          0         15          0         15       $2.09        $2.56    2.074              L3-00005      1   00:00:00        $.02          0          0          0          0        $.00         $.02     .016              L4-00005     92   00:00:10       $2.81          0          0          0          0        $.00        $2.81    2.277              N1-00005     14   00:00:05       $1.49          2          1          1          4        $.56        $2.05    1.661              OP-00005      1   00:00:00        $.01          0          0          0          0        $.00         $.01     .008              RC-00005     65   00:00:02        $.43          0          0          0          0        $.00         $.43     .348              RI-00005     40   00:00:01        $.27          0          0          0          0        $.00         $.27     .219              S2-00005     13   00:00:19       $5.40          0         39          0         39       $5.42       $10.82    8.768              S4-00005    122   00:00:06       $1.76          0          0          0          0        $.00        $1.76    1.426         17810            416   00:01:02      $17.36         32         62          3         97      $13.49       $30.85   24.997  ADABASX2              1,078   00:02:50      $47.21        111        169          5        285      $39.63       $86.84   70.368

ADABAS Job Charge Detail Report (2 of 2):

                                        A D A B A S    J O B    C H A R G E    D E T A I L  BEGIN DATE - 07/21/94                                                                                         RUN DATE - 08/15/94  END DATE   - 07/21/94                                                                                                    PAGE   2         TERM CM FILE     CMD  ESTIMATED     PROCESS ASSOCIATOR       WORK       DATA      TOTAL         I/O        TOTAL  PERCENT  JOBNAME ID  CD  NBR   COUNT  CPU  TIME      CHARGE  I/O COUNT  I/O COUNT  I/O COUNT  I/O COUNT      CHARGE       CHARGE    TOTAL  CICS15X         03085                -00000      1   00:00:00        $.00          0          0          0          0        $.00         $.00     .000              BT-00004      1   00:00:00        $.01          0          0          0          0        $.00         $.01     .008              ET-00000      2   00:00:00        $.04          0          1          0          1        $.14         $.18     .146              L2-00001  1,004   00:00:45      $12.61          2          0         46         48       $6.72       $19.33   15.664              L2-00002    380   00:00:17       $4.71          2          0         13         15       $2.10        $6.81    5.519              L3-00004     52   00:00:03        $.76          6          0         24         30       $4.17        $4.93    3.995              L9-00004      3   00:00:00        $.06          1          0          0          1        $.14         $.20     .162              N1-00004      1   00:00:00        $.04          0          0          0          0        $.00         $.04     .032              OP-00004      1   00:00:01        $.21          7          1          1          9       $1.25        $1.46    1.183              RC-00000      4   00:00:00        $.03          0          0          0          0        $.00         $.03     .024              RC-00004     17   00:00:00        $.11          0          0          0          0        $.00         $.11     .089              S1-00004      6   00:00:02        $.45          3          1          5          9       $1.25        $1.70    1.378         03085          1,472   00:01:09      $19.03         21          3         89        113      $15.77       $34.80   28.200  CICS15X               1,472   00:01:09      $19.03         21          3         89        113      $15.77       $34.80   28.200  KWL1PR05              BT-00004      3   00:00:00        $.03          0          0          0          0        $.00         $.03     .024              CL-00004      3   00:00:00        $.03          0          0          0          0        $.00         $.03     .024              L3-00004      9   00:00:00        $.07          1          0          1          2        $.28         $.35     .283              OP-00004      3   00:00:00        $.09          0          2          0          2        $.28         $.37     .300              RC-00000      3   00:00:00        $.03          0          0          0          0        $.00         $.03     .024              RC-00004      6   00:00:00        $.03          0          0          0          0        $.00         $.03     .024              S1-00004      3   00:00:01        $.23          4          0          1          5        $.70         $.93     .753                           30   00:00:02        $.51          5          2          2          9       $1.26        $1.77    1.432  KWL1PR05                 30   00:00:02        $.51          5          2          2          9       $1.26        $1.77    1.432                        2,580   00:04:00      $66.75        137        174         96        407      $56.66      $123.41  100.000  CAJS003I NORMAL END OF PROCESSING

ADABAS Job Charge Summary Report

The sample ADABAS Job Charge Detail Report, shown below, was obtained by executing a modified version of member ADASUMR in the source library. The following system control statements were used.

System Control Statements

1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80
 CONFIG  OTHE01F
 SELECT       1                                   0

These Report Writer control statements were used to produce the report.

Report Control Statements

1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80
 CONFIG  OTHE01F
 SELECT       1                                   0
0HEADER     A D A B A S    J O B    C H A R G E    S U M M A R Y
0SORT    01608A1109908A1
0DISPLAY QA002056166144133134139140145146142
0RATE     1000500       100      001001         001
0DESCRIPT2****1281
0DESCRIPT1****0181
0TITLE   02           TERMINAL JOBNAME    ID
1...5...10...15...20...25...30...35...40...45...50...55...60...65  .80

ADABAS Job Charge Summary Report:

                                       A D A B A S    J O B    C H A R G E    S U M M A R Y  BEGIN DATE - 07/21/94                                                                                        RUN DATE - 08/15/94  END DATE   - 07/21/94                                                                                                   PAGE   1             TERMINAL    CMD  ESTIMATED     PROCESS ASSOCIATOR       WORK       DATA      TOTAL         I/O        TOTAL  PERCENT  JOBNAME    ID        COUNT  CPU  TIME      CHARGE  I/O COUNT  I/O COUNT  I/O COUNT  I/O COUNT      CHARGE       CHARGE    TOTAL  ADABASX2             01541       604   00:01:36      $26.80         39         98          1        138      $19.19       $45.99   37.267             02923        58   00:00:11       $3.05         40          9          1         50       $6.95       $10.00    8.104             17810       416   00:01:02      $17.36         32         62          3         97      $13.49       $30.85   24.997  ADABASX2             1,078   00:02:50      $47.21        111        169          5        285      $39.63       $86.84   70.368  CICS15X             03085     1,472   00:01:09      $19.03         21          3         89        113      $15.77       $34.80   28.200  CICS15X              1,472   00:01:09      $19.03         21          3         89        113      $15.77       $34.80   28.200  KWL1PR05                          30   00:00:02        $.51          5          2          2          9       $1.26        $1.77    1.432  KWL1PR05                30   00:00:02        $.51          5          2          2          9       $1.26        $1.77    1.432                       2,580   00:04:00      $66.75        137        174         96        407      $56.66      $123.41  100.000  CAJS003I NORMAL END OF PROCESSING