5. FILES › 5.2 CICS Information Area Files › 5.2.6 CICS User Activity File (CICCSU) › 5.2.6.4 CICCSU Retrieval Examples

5.2.6.4 CICCSU 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 by the first level of user identification.

      PROC CHART DATA=&PCICD..CICCSU01;
      HBAR CICACT1 / SUMVAR=CSUCPUTM DESCENDING;
      RUN;

2.  Generate a summary report showing workload and
    performance-related information by CICSID and the first
    level of user identification for the day before
    yesterday.

      %LET BY = CICSID CICACT1;
      %LET BREAK = CICACT1;

      PROC SORT DATA=&PCICD..CICCSU02;
      BY &BY;
      RUN;

      DATA SUMCSU(KEEP=CICSID CICACT1 MONTH YEAR DAY
       CSUCPUTM CSUSIOCT CSUTLOPS CSUTRANS CSUAVTTM
       CSUSOS CSUMXTSK CSUPAGIN CSUFCWAT CSUTLWAT);
      SET CICCSU;
      BY &BY;
      %CSUSUM(SUMBY=&BY,SUMBREAK=&BREAK,OUT=SUMCSU,
      DERV=YES);
      RUN;

      PROC PRINT DATA=SUMCSU N; BY CICSID;
      PAGEBY CICSID;
      ID CICACT1;
      VAR MONTH YEAR DAY
      CSUCPUTM CSUTRANS CSUTLOPS CSUSIOCT CSUAVTTM
      CSUSOS CSUMXTSK CSUPAGIN CSUFCWAT CSUTLWAT;
      RUN;