Previous Topic: 5.4.5.3 DESSYU Usage Considerations

Next Topic: 6. DATA SOURCES

5.4.5.4 DESSYU Retrieval Examples


This section presents typical DESSYU retrieval examples.

1.  Print a list of Initial, Current, and Maximum Nonpaged
    Dynamic Memory readings from DEXSUS for the last seven
    days for node DEV1.

    DATA;
    SET %MFILE(TS=DA,DB=p,F=SYU07-01);
    IF SYSID='DEV1';
    PROC PRINT;
     VAR SYUMENDI SYUMENDC SYUMXMEN;
    RUN;

2.  Print a report of maximum VMS memory utilization by
    hour of day for the last seven days for node DEV1.  This
    example merges the Minimum Free Page Count element
    (SPRMNIFP) from the System Profile (DEMSPR) file with the
    Main Memory element (SYUMEMAN) from the System Status
    (DESSYU) file to derive a memory utilization value.


    %LET BY=SYSID YEAR MONTH DAY;
    DATA SPR1;
     SET %MFILE(TS=DA,DB=p,F=SPR07-01);
     IF SYSID='DEV1';
     KEEP &BY HOUR SPRMNIFP;
    PROC SORT; BY &BY HOUR;
    DATA SYU1;
     SET %MFILE(TS=DA,DB=p,F=SYU07-01);
     IF SYSID='DEV1';
    PROC SORT; BY &BY;
    DATA MEM1; MERGE SPR1 SYU1;
     BY &BY;
     IF SYUMEMAN GT 0 THEN
      PCTMEMUS=(1-((SPRMNIFP*512)/(SYUMEMAN*(2**20))));
    PROC PRINT DATA=MEM1;
     BY &BY; ID &BY;
     VAR HOUR PCTMEMUS SPRMNIFP SYUMEMAN SYUHWNAM;
     FORMAT PCTMEMUS PERCENT8.1 YEAR MONTH DAY HOUR 2.;
    RUN;