5. FILES › 5.3 VMX Information Area Files › 5.3.11 VMX User Activity Data Files (VMXVXU and VMX_VU) › 5.3.11.4 VMXVXU and VMX_VU Retrieval Examples

5.3.11.4 VMXVXU and VMX_VU Retrieval Examples

VMXVXU EXAMPLE

 Print CPU consumed for the top ten users on the system.

   DATA CPU(KEEP=SYSID USER DATE
       VXUTTIME VXUVTIME TVRATIO);
     SET &VMXX..VMXVXU01; BY SYSID USER;
     FORMAT DATE DATE7.;
     LABEL TVRATIO='Total to*Virtual Ratio'
     IF FIRST.USER THEN DO;
       Z1=0;Z2=0;
     END;
     Z1+VXUTTIME;
     Z2+VXUVTIME;
     IF LAST.USER;
     VXUTTIME = Z1;
     VXUVTIME = Z2;
     TVRATIO = VXUVTIME > 0;
     IF TVRATIO THEN TVRATIO = VXUTTIME/VXUVTIME;
     DATE = DATEPART(ENDTS);
   RETURN;
   PROC SORT;
     BY SYSID DATE DESCENDING VXUTTIME;
   RUN;
   DATA CPU;
     SET CPU;
     RANK+1;
     OUTPUT;
     IF RANK = 20 THEN STOP;
   RETURN;
   PROC PRINT  SPLIT='*';
     BY SYSID DATE;
     ID RANK;
     TITLE "Top 20 Users by CPU Consumption";
   RUN;

VMX_VU EXAMPLE

   Show interaction duration as a function of page faults.

   DATA MERGED(KEEP=SYSID USER
          VMXCPUAD ENDTS VXUPGFLT TRNTM);
     MERGE &VMXX..VMX_VU01 &VMXX..VMX_VT01;
     BY SYSID USER VMXCPUAD VXUPRXTS;
     LABEL TRNTM='Transaction Time';
     TRNTM = VXUSUSTS-VXUTRNTS;
   RUN;
   PROC PLOT;
     PLOT TRNTM*VXUPGFLT /
     vaxis=0 to 25 by 5;
     TITLE
        "Interaction Duration as a Function of Page Faults";
   RUN;