Reporting Examples › 6.13 Identify Transactions Used by CICS Users

6.13 Identify Transactions Used by CICS Users

PROBLEM:

    The enforcement of standards, security, productivity, and
    performance guidelines necessitates a study of the CICS
    users' transaction profile.  A cross-tabulation report
    listing the transaction name and quantifying the number
    of times used by specific CICS cost centers is required.


DATABASE FILES TO BE ACCESSED:

    &MCICD..CICCSU01
        Yesterday's CICS User Activity File. (Note that we
        assume the default account code structure is being
        used so that CICACT1 contains the cost center code
        and CICACT2 contains the transaction ID.)


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    PROC FREQ may be used to produce a cross-tabulation
    report of transaction name by cost center.


SAS CODE EXAMPLE:

************************************************************;
* CICS TRANSACTION USAGE ANALYSIS REPORT                   *;
* ANALYSIS FOR COST CENTERS PXB1, PXB2, AND PXG1           *;
************************************************************;
 DATA;
  SET &MCICD..CICCSU01;
  IF CICACT1='PXB1' OR CICACT1='PXB2' OR CICACT1='PXG1';
 PROC FREQ; TABLES CICACT2*CICACT1 /
  NOCOL NOPERCENT NOROW;
 TITLE "CICS TRANSACTION USAGE ANALYSIS REPORT";
 TITLE2 "ANALYSIS FOR COST CENTERS PXB1, PXB2, AND PXG1";


GENERATED OUTPUT REPORT:

    Figure 6-11 illustrates the output reports produced by
    the SAS code illustrated above.

 
  CICS TRANSACTION USAGE ANALYSIS REPORT                        15:03 Tuesday, September 7, yyyy   1
  ANALYSIS FOR COST CENTERS PXB1, PXB2, AND PXG1
 
  The FREQ Procedure
 
  Table of CICACT2 by CICACT1
 
  CICACT2(TRANSACTION ID)     CICACT1(COST CENTER)
 
  Frequency|   PXB1 |   PXB2 |   PXG1 |  Total
  ---------+--------+--------+--------+
  AADB     |      0 |      2 |      1 |      3
  ---------+--------+--------+--------+
  AAON     |      5 |      4 |      4 |     13
  ---------+--------+--------+--------+
  AARB     |      2 |      1 |      2 |      5
  ---------+--------+--------+--------+
  AE08     |      2 |      1 |      2 |      5
  ---------+--------+--------+--------+
  AE16     |      3 |      4 |      3 |     10
  ---------+--------+--------+--------+
  AE21     |      0 |      1 |      0 |      1
  ---------+--------+--------+--------+
  AE22     |      6 |      7 |      8 |     21
  ---------+--------+--------+--------+
  AE27     |      0 |      0 |      1 |      1
  ---------+--------+--------+--------+
  AE30     |     46 |     50 |     50 |    146
  ---------+--------+--------+--------+
  AE34     |      1 |      1 |      1 |      3
  ---------+--------+--------+--------+
  AFCB     |      2 |      2 |      4 |      8
  ---------+--------+--------+--------+
  AFCZ     |      1 |      0 |      1 |      2
  ---------+--------+--------+--------+
  AFC9     |      0 |      1 |      1 |      2
  ---------+--------+--------+--------+
  AIS$     |      6 |      4 |      5 |     15
  ---------+--------+--------+--------+
  AJSB     |      6 |      8 |      7 |     21
  ---------+--------+--------+--------+
  AMD2     |      7 |      7 |      8 |     22
  ---------+--------+--------+--------+
  AR20     |      1 |      2 |      0 |      3
  ---------+--------+--------+--------+
  AR21     |      3 |      3 |      4 |     10
  ---------+--------+--------+--------+
  AR22     |      0 |      1 |      1 |      2
  ---------+--------+--------+--------+
  ATMG     |      1 |      1 |      0 |      2
  ---------+--------+--------+--------+
  Total          92      100      104      296
 
 

Figure 6-11.  CICS Transaction Usage Analysis