Previous Topic: What Do the Fields Mean?Next Topic: Understanding the ACFRPTRX Report


Advantage CA-Earl Example

Advantage CA-Earl is the CA Technologies Easy Access Report Language. It provides a standard facility for you to create customized CA ACF2 Option for DB2 reports quickly and easily. It enables you to write new reports and to include your own information in SMF records. The CA ACF2 Reporting with Advantage CA-Earl guide describes how to use the Advantage CA-Earl facility for CA ACF2 Option for DB2 reports.

This example is a summary of resource violations sorted by the logonid that caused the violation. You can find the input source for this report in the CA ACF2 Reporting with Advantage CA-Earl guide.

06/11/05              RESOURCE VIOLATIONS BY VIOLATOR NAME            PAGE     1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
NAME                 REC  LOOKUP KEY                                      NUMBER
                     MODE
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
YVONNE               LOG  DDBS****DBASE***                                  1
                                                                      ‑‑‑‑‑‑‑‑‑‑
YVONNE                                                                        1

CARL                 LOG  DSYS****SYSADM                                    1
                                                                      ‑‑‑‑‑‑‑‑‑‑
CARL                                                                          1

STEVE                LOG  DPLNDSNPPLNDB2**                                  1
STEVE                VIO  DTBL****USER01*********************               1
                                                                      ‑‑‑‑‑‑‑‑‑‑
STEVE                                                                         2
                                                                      ‑‑‑‑‑‑‑‑‑‑
06/11/05              RESOURCE VIOLATIONS BY VIOLATOR NAME            PAGE     5
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
NAME                 REC  LOOKUP KEY                                      NUMBER
                     MODE
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
                                                                      ‑‑‑‑‑‑‑‑‑‑
GRAND TOTAL                                                                 369
                                                                      ‑‑‑‑‑‑‑‑‑‑
  REPORT   RECORDS READ   LINES PRINTED
       1            369             224
**** REPORT PHASE ENDED   0.24 SECONDS.