5. FILES › 5.2 CICS Information Area Files › 5.2.5 CICS File/DBD Activity File (CICCSF) › 5.2.5.4 CICCSF Retrieval Examples

5.2.5.4 CICCSF 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.  Print yesterday's file usage by hour.

      PROC PRINT DATA=&PCICD..CICCSF01;
      ID HOUR; VAR CICSID CSFFID CSFADD CSFGET
      CSFUPD CSFBROW;
      SUM CSFADD CSFGET CSFUPD CSFBROW;
      RUN;

2.  Provide a summary of file access  by  VOLSER from the day
    before yesterday.

      %LET BY= VOLSER CSFFID;
      %LET BREAK = VOLSER;

      PROC SORT DATA=&PCICD..CICCSF02 OUT=CICCSF;
      BY &BY;
      RUN;

        DATA SUMVOL(KEEP=VOLSER FILE_TOT CSFACCCT CSFACCTM
          CSFVSMBW CSFVSMSP CSFVSMSW);
        SET CICCSF; BY &BY;
        IF FIRST.CSFFID THEN FILE_NUM+1;
        IF LAST.&BREAK THEN DO;
          FILE_TOT=FILE_NUM;
          FILE_NUM=0;
        END;
        %CSFSUM(SUMBY=&BY;SUMBREAK=&BREAK,OUT=SUMVOL);
        RUN;

        PROC PRINT DATA=SUMVOL;
        VAR VOLSER FILE_TOT CSFACCCT CSFACCTM CSFVSMBW
          CSFVSMSW CSFVSMSP;
        SUM FILE_TOT CSFACCCT CSFACCTM CSFVSMBW CSFVSMSW
          CSFVSMSP;
        RUN;