Previous Topic: 5.2.4.2 IMSIAC Data Elements ListNext Topic: 5.2.5 IMS Incident File (IMSINC)


5.2.4.3 IMSIAC Usage Considerations

This section identifies any special considerations or
techniques related to using the IMSIAC file.  Additionally,
sample retrieval examples are provided to help you use this
file.


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.

Special Considerations/Techniques

1.  The following data elements are reserved in this record
    for future use:

      IACCOST  - Processing Charges

2.  Be careful using the special date and time data elements
    contained in each CA MICS file. As the IMSIAC file's
    granularity increases in higher timespans, the following
    fields lose significance and should not be used in the
    case described:

        o  HOUR should not be used in MONTHS and YEARS.
        o  DAY and DAYNAME should not be used in MONTHS
           or YEARS.
        o  WEEK should not be used in MONTHS or YEARS.
        o  MONTH should not be used in YEARS.

3.  The STARTTS and ENDTS, when appearing in the DAYS, WEEKS,
    MONTHS, or YEARS timespans, mark the span of time over
    which the data has been summarized, with STARTTS being
    the lowest (earliest) date and time and ENDTS the highest
    (latest) date and time.

Retrieval Examples

1.  Generate a horizontal bar graph of transaction
    executions by the first level of user
    identification:

    PROC CHART DATA=&PIMSD..IMSIAC01;
    HBAR IMSACT1 / SUMVAR=EXECUTES DESCENDING;
    RUN;

2.  Generate a frequency table of the occurrence of large
    input messages, by application unit.  Use a part of
    yesterday's data as input.

    OPTIONS OBS=1000;
    DATA TEMP (KEEP=IMSAPU IACMXILN);
    SET &PIMSD..IMSIAC01;
      IF IACMXILN GT 1000  THEN OUTPUT TEMP;
    PROC FREQ DATA=TEMP;
       TABLES IMSAPU / NOROW NOCOL;
       RUN;