5. FILES › 5.2 CICS Information Area Files › 5.2.2 CICS Application Unit Activity File (CICCAU) › 5.2.2.4 CICCAU Retrieval Examples

5.2.2.4 CICCAU Retrieval Examples

In the examples, a SAS macro variable is used to specify the
DDname part of the CA MICS file name. These macro variables
are a standard part of CA MICS and are available for all
files. The macro variable name has the form &diiit, where d
is the database identifier, iii is the information area
name, and t is the timespan.  For the examples, a database
identifier of P is used.  The identifier is installation
dependent, so you should find out what the identifiers are at
your installation.

1.  Generate a horizontal bar graph of transaction CPU time
    used yesterday by application unit.

      PROC CHART DATA=&PCICD..CICCAU01;
      HBAR CICAPU / SUMVAR=CAUCPUTM DESCENDING;
      RUN;

2.  Generate a summary report showing workload and
    performance information by CICSID and application unit
    for the last three days.

      %LET BY = CICSID CICAPU MONTH YEAR DAY;
      %LET BREAK = DAY;
      DATA CICCAU(KEEP=%CAUKEEP(OP=FILEOPTS,TS=DAYS));
      SET &PCICD..CICCAU03
          &PCICD..CICCAU02
          &PCICD..CICCAU01;
      RUN;
      PROC SORT DATA=CICCAU;
      BY &BY;
      RUN;

      DATA SUMCAU(KEEP=CICSID CICAPUB MONTH YEAR DAY
       CAUCPUTM CAUSIOCT CAUTLOPS CAUTRANS CAUAVTTM
       CAUSOS CAUMXTSK CAUPAGIN CAUFCWAT CAUTLWAT);
      SET CICCAU;
      BY &BY;
      IF FIRST.CICAPU THEN CICAPUB=CICAPU;
      ELSE CICAPUB=' ';
      %CAUSUM(SUMBY=&BY,SUMBREAK=&BREAK,OUT=SUMCAU,
      DERV=YES);
      RUN;

      PROC PRINT DATA=SUMCAU N; BY CICSID;
      PAGEBY CICSID;
      ID CICAPUB;
      VAR MONTH YEAR DAY
      CAUCPUTM CAUTRANS CAUTLOPS CAUSIOCT CAUAVTTM
      CAUSOS CAUMXTSK CAUPAGIN CAUFCWAT CAUTLWAT;
      RUN;