SAS reports

Sample programs are included in your BBSAMP data set to create SAS reports from data collected by MainView for CICS. Copies of these sample programs can be modified to create unique SAS reports.

Note

When file expansion is turned on (FILEXPND=YES in CMRSOPT), the structure of expanded resource entries varies by type (that is, a file resource entry differs from a WebSphere MQ entry at the same offsets). A batch program that is processing the first field in each expanded resource entry receives file reads for a file resource entry, select counts for a DB2 resource entry, and open counts for a WebSphere MQ resource entry. All customized programs must process the resource entries separately by using the T6EFILEI field to determine the entry type. Entries of different types should not be processed together.

This chapter contains

  • control statements to specify the input data for SAS programs
  • descriptions of SAS report fields
  • examples of SAS reports

Detail transaction records are compressed when they are stored on the CMRDETL data set. You have the choice of creating SAS reports from compressed or decompressed 6E and 6D records. You must run a separate job if you want to create SAS reports with decompressed CMRDETL records.

Member CMRSA10N of your BBSAMP data set decompresses 6E and 6F records. The decompressed output records are compatible with SAS programs. Edit a copy of CMRSA10N and run the program to create decompressed detail transaction records before running your SAS report programs.

Note

Be sure to run your SAS report programs using the current version of the MainView for CICS libraries.

The MainView for CICS SAS reporting facility supports the F7 formats of the T6E history record. See Transaction-detail-data-CMRDETL for information about the F7 record.

The following information is available for the F7 level history records:

  • CMRNIFUE is the SAS in-file user exit that reads and decompresses T6E records
  • SASI6ExN members in the BBSAMP data set are SAS formats for the various sections of the T6E record
  • CMRSAxxN members in the BBSAMP data set are sample programs
  • CMRCMPWN reads the CMRDETL records and decompresses them to the F7 format

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*