5. FILES › 5.3 VMX Information Area Files › 5.3.12 VMX User Transaction Data Files (VMXVXT and VMX_VT) › 5.3.12.4 VMXVXT and VMX_VT Retrieval Examples

5.3.12.4 VMXVXT and VMX_VT Retrieval Examples

 VMXVXT EXAMPLE

 List users ranked by IUCV and VCMF activity as measured by
 external interrupts generated as a part of using these
 facilities.

   %VMCBRK(FILE=VMXVXT01,
           START='08:45'T,END='09:00'T,PERIOD=15);
   RUN;
   %LET BY = SYSID DATE USER TIME;
   %LET BREAK = TIME;
   PROC SORT DATA=VMXVXT;
     BY &BY;
   RUN;
   DATA VMXVXT;
     SET VMXVXT;
     %VXTSUM(DERV=YES);
   RUN;
   PROC SORT;
     BY SYSID DATE DESCENDING VXUEXTRF;
   RUN;
   DATA VMXVXT;
     SET VMXVXT;
     RANK+1;
     OUTPUT;
     IF RANK = 20 THEN STOP;
   RETURN;
   PROC PRINT  SPLIT='*'; BY SYSID DATE;
     ID RANK;
     VAR USER VXUEXTRF VXUSVMWT
              VXUE0CT VXUE1CT VXUE2CT VXUE3CT
              VXUQ0CT VXUQ1CT VXUQ2CT VXUQ3CT;
     TITLE "Top 20 Users by IUCV/VMCF Activity";
   RUN;


 VMX_VT EXAMPLE

 Plot the elapsed times between interaction start and
 interaction end (time suspended) and between interaction end
 and dispatch list drop.  The transaction start to end time
 will be displayed as a negative number.

   %VMCBRK(FILE=VMX_VT01,
           START='08:30'T,END='08:45'T,PERIOD=15);
   IF USER =: 'AL';             /* SUBSET USERS          */
   DLD = VXUDLDTS - VXUSUSTS;   /* TIME TO DLIST DROP    */
   TRN = VXUTRNTS - VXUSUSTS;   /* TIME FROM TRANS START */
   RUN;
   PROC TIMEPLOT;
     BY SYSID USER VMXCPUAD;
     PLOT TRN = '<' DLD = '>'
        / REF=0 JOINREF OVERLAY  AXIS=-2.5 TO .5 BY .05;
     ID VXUTRNTS VXUSVMID;
     LABEL DLD='Trans. End to DLIST Drop'
           TRN='Trans. Start to End';
   RUN;