5. FILES › 5.3 IDMS Information Area Files › 5.3.2 IDMS Application Unit Activity File (IDMSAU) › 5.3.2.4 Retrieval Examples

5.3.2.4 Retrieval Examples

This section presents several retrieval examples for the
IDMS Application Unit Activity File.

In the examples, several CA MICS macros are used to specify
the files used and the summarization done.  Further
information on summarization is found in the MICF Tutorial in
the MICF User Guide.

1. Generate a list of all IDMS program names.

    DATA;
    SET DETAIL.IDMSAU01;
    IF IDMTYPE='C';
    PROC FREQ;
    TABLES SAUPGM;

2. Print the average and maximum IDMS short response time for
   application unit APU001 each hour between 8 am and 5 pm
   yesterday for IDMS system IDM1.

    DATA;
    SET DAYS.IDMSAU01;
    IF IDMSID='IDM1';
    IF HOUR GE 8 AND HOUR LE 17;
    IF IDMAPU='APU001';
    PROC PRINT;
    VAR HOUR SAUAVSTM SAUMXSTM;

3. Print the number of terminal errors for each hour of the
   day.

    DATA;
    SET DAYS.IDMSAU01;
    PROC PRINT;
    VAR IDMSID HOUR SAUTERRS;