5. FILES › 5.3 IDMS Information Area Files › 5.3.6 IDMS User Activity File (IDMSUA) › 5.3.6.4 Retrieval Examples

5.3.6.4 Retrieval Examples

This section presents several retrieval examples for the IDMS
User 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. Print the average IDMS conversational response time for
   program UPDT01 each hour between 8 a.m. and 5 p.m.
   yesterday for IDMS system IDM1.

    DATA;
    SET DAYS.IDMSUA01;
    IF IDMSID='IDM1';
    IF HOUR GE 8 AND HOUR LE 17;
    IF IDMACT2='UPDT01';
    PROC PRINT;
    VAR HOUR SUAAVCTM;

2. Print the ratio of pages read to pages requested for each
   IDMS system yesterday by hour for each program.

    %INCLUDE INCLLIB(#IDMMACS);
    MACRO _BY IDMSID IDMACT2 HOUR %
    MACRO _BREAK HOUR %
    PROC SORT DATA=DAYS.IDMSUA01 OUT=WORK1; BY _BY;
    DATA WORK1;
    SET WORK1;
    _SUASUM;
    DATA;
    SET WORK1;
    RATIO=SUAPREAD/SUAPREQ;
    PROC PRINT;
    VAR IDMSID IDMACT2 HOUR RATIO;