5. FILES › 5.7 UNIX Disk Activity File (AUMDDA) › 5.7.4 AUMDDA Retrieval Examples

5.7.4 AUMDDA Retrieval Examples

List disk utilization, physical and logical I/O rate, and
average queue length for disk devices on the system.  Disk
devices on the report are ranked in descending order of how
busy a device was.


 %LET BY = SYSID YEAR MONTH DAY DDANAME;
 %LET BREAK = DDANAME;
 PROC SORT DATA=DAYS.AUMDDA01 OUT=DDA;
   BY &BY;
 RUN;

 %MACRO NEGATE;
   PSRAWIO = SUM(DDAPSRWT,DDAPSRRD);
   PSFILEIO = SUM(DDAPSFWT,DDAPSFRD);
   PSLOGIO = SUM(DDAPSLWT,DDAPSLRD);
   LABEL PSRAWIO = 'Raw I/O Rate'
         PSFILEIO = 'File System I/O Rate'
         PSLOGIO = 'Logical I/O Rate';
 %MEND;

 DATA DDA;
   SET DDA;
   DATE = DATEPART(ENDTS);
   FORMAT DATE MMDDYY8.;
   %DDAFMT(TS=DAYS,DERV=YES);
   %DDALBL(DERV=YES);
   %DDASUM;
 RUN;

 %LET BY = SYSID DATE;
 %LET BREAK = DATE;
 PROC SORT; BY &BY DESCENDING DDAPCDUT;
 DATA DDA2 (KEEP=&BY DDANAME DURATION DDAPCDUT
            DDADUTTM DDAAVQLN DDAPSMEM DDAPSSYS PSRAWIO
            PSFILEIO PSLOGIO RANK);
   SET DDA;
   BY &BY;
   RETAIN RANK 0;
   IF FIRST.&BREAK THEN RANK = 0;
   RANK+1;
   OUTPUT;
   LABEL RANK = 'Rank';
   FORMAT DDAPSMEM DDAPSSYS PSRAWIO PSFILEIO PSLOGIO 8.2;
 RUN;

 PROC PRINT LABEL;
   BY &BY;
   PAGEBY &BREAK;
   ID RANK;
   VAR  DDANAME DURATION DDAPCDUT DDADUTTM DDAAVQLN
        DDAPSMEM DDAPSSYS PSRAWIO PSFILEIO PSLOGIO
        ;
   TITLE "Daily Disk Activity Ranked by Disk Busy";
 RUN;