3.1.1 VAX/VMS Workload Analysis Inquiries

3. REPORTS › 3.1 MICF Inquiries for VAX/VMS › 3.1.1 VAX/VMS Workload Analysis Inquiries

3.1.1 VAX/VMS Workload Analysis Inquiries

 
This section lists the MICF Inquiries for VAX/VMS workload 
analysis.  A brief description is given for each CA MICS 
VAX/VMS Analyzer inquiry in this category.  Sample report 
output follows this section.
 
 
 
DEXLX0 - Resource Intensive Processes: (4 reports)
         CPU, I/O, Image Activations, and Paging
 
    Sample: Fig 3-101 and 3-102.
 

This inquiry shows you in a single report who is using
the largest amounts of key system resources in a
single process.  The report shows the top 25 resource
users for each of the following measures:

   o  CPU Time
   o  Direct I/Os
   o  Image Activations
   o  Page File Peak usage

A separate report page is printed in ranked list format
for each of the measures, with identification of the time
and the user (process) consuming the resource.  You can
modify this inquiry to include other measurements of
interest or expand the size of the ranking list you want
to view.

 
 
DEXPX1 - Process Terminations Status
DEXCX1
 
    Sample: Fig 3-103.
 

    This inquiry is useful in determining the size and
    composition of the workload running on each VMS system,
    based on VMS Accounting measurements.  The report shows
    the overall distribution of process terminations by hour
    of day.  Each hourly measure is broken down by type of
    termination (for example, success, warning, error) based
    on the final status of the last image run by the process.
    This inquiry can be easily customized to provide other
    breakdowns, such as by process type, account codes, or
    user names.


 
DEXLW0 - Weekly Process Name Summary
 
    Sample: Fig 3-104.
 


    This inquiry is useful in determining the overall size
    and composition of the workload running on each VMS
    system, based on VMS Monitor measurements.  The report
    lists process activity by week and time zone, for
    each process name prefix.  This prefix is defined as the
    first part of process name (typically a user name), up to
    8 characters, prior to special characters such as
    underscore.  This grouping of process names gives a
    compact summary of process activity while retaining
    enough information to help determine the type of workload
    represented.

    The report shows the summarized values for each of the
    following measures:

     o  CPU Time
     o  Direct I/Os
     o  Page Faults
     o  Total Recording Interval Time

    You can modify this inquiry to include other MONITOR
    PROCESS measurements of interest.


 
DEXLW1 - Weekly Process Activity
 
    Sample: Fig 3-105.
 


    This inquiry is useful in determining the size and
    composition of the workload running on each VMS system,
    based on a combination of VMS Accounting and VMS Monitor
    measurements.  The report shows the distribution of
    process activity by zone summed over an entire week.
    Each measure is broken down by hour of day, process type
    (for example, batch, interactive, detached), and UIC
    group, based on the combination of Monitor and Accounting
    PROCESS records from the DESPRX file.

    The report shows the summarized values for each of the
    following measures:

     o  CPU Time
     o  Direct I/Os
     o  Buffered I/Os
     o  Page Faults
     o  Maximum Global and Process Pages

    You can modify this inquiry to include other MONITOR
    PROCESS measurements of interest, with other breakdowns
    such as by user name.

 
 
DEXLM1 - Monthly Process Activity
 
    Sample: Fig 3-106.
 

    This inquiry is useful in determining the size and
    composition of the workload running on each VMS system,
    based on a combination of VMS Accounting and VMS Monitor
    measurements.  The report shows the distribution of
    process activity summed over an entire month.  Each
    measure is broken down by zone, process type (for
    example, batch, interactive, detached), and UIC group,
    based on the combination of Monitor and Accounting
    PROCESS records from the DESPRX file.

    The report shows the summarized values for each of the
    following measures:

     o  CPU time
     o  Direct I/Os
     o  Buffered I/Os
     o  Page Faults
     o  Maximum Global and Process Pages

    You can modify this inquiry to include other MONITOR
    PROCESS measurements of interest, with other breakdowns
    such as by user name.

INQUIRY: DEXLX0 ---------------------------------- PRCCPUTM 0:02:55.54 0:01:39.68 0:01:14.44 0:01:00.03 0:00:56.53 0:00:45.06 . . . . INQUIRY: DEXLX0 ---------------------------------- PRCDIRIO . . . . CPU Time - Top 25 Processes RUN DATE: 24JUL08 -------------------- System Identifier=VMS2 ---------------------------------------------------- ENDTS DEXUSER DEXGRP DEXMBR 11JUL08:00:04:45.55 JQINJQ 200 2 11JUL08:15:56:15.31 DD9RV54 1 1 11JUL08:11:56:47.20 JQINJQ 200 2 11JUL08:13:25:46.58 JQINJQ 200 2 11JUL08:15:56:14.60 DD9RV54 1 1 11JUL08:14:33:04.01 DD9RV54 1 1 . . . . . . . . . . . . . . . . Direct I/Os - Top 25 Processes RUN DATE: 24JUL08 -------------------- System Identifier=VMS2 ---------------------------------------------------- ENDTS DEXUSER DEXGRP DEXMBR 2872 11JUL08:00:04:45.55 JQINJQ 200 2 1922 11JUL08:00:08:34.64 JQINJQ 200 2 1758 11JUL08:13:25:46.58 JQINJQ 200 2 468 11JUL08:11:56:47.20 JQINJQ 200 2 356 11JUL08:15:56:14.60 DD9RV54 1 1 . . . . . . . . . . . . . . . .


Figure 3-101. Resource Intensive Processes - CPU & I/O

Image Activations - Top 25 Processes INQUIRY: DEXLX0 RUN DATE: 24JUL08 ------------------------------------------------------ System Identifier=VMS2 ---------------------------------------------------- PRCIMAGE ENDTS DEXUSER DEXGRP DEXMBR 56 11JUL08:15:56:14.60 DD9RV54 1 1 54 11JUL08:00:04:45.55 JQINJQ 200 2 33 11JUL08:11:56:47.20 JQINJQ 200 2 11 11JUL08:13:25:46.58 JQINJQ 200 2 5 11JUL08:16:50:54.08 DD9GW20 200 73 5 11JUL08:17:54:31.66 DD9GW20 200 73 . . . . . . . . . . . . . . . . . . . . Page File Peak Usage - Top 25 Processes INQUIRY: DEXLX0 RUN DATE: 24JUL08 ------------------------------------------------------ System Identifier=VMS2 ---------------------------------------------------- PRCPAGFL ENDTS DEXUSER DEXGRP DEXMBR 11555 11JUL08:18:16:19.87 DD9GW20 200 73 10402 11JUL08:00:04:45.55 JQINJQ 200 2 10139 11JUL08:16:50:54.08 DD9GW20 200 73 10034 11JUL08:17:54:31.66 DD9GW20 200 73 10034 11JUL08:14:36:09.03 MA9KM38 300 10 7028 11JUL08:14:47:49.80 DD9RV54 1 1 . . . . . . . . . . . . . . . . . . . .

Figure 3-102. Resource Intensive Processes - Images & Paging

Process Terminations Status INQUIRY: DEXPX1 RUN DATE: DDMMMYY SYSID=VMS1 Month=7 Day=17 FREQUENCY BAR CHART FREQUENCY | SSSS 210 + SSSS | SSSS | SSSS | SSSS 180 + SSSS SSSS | SSSS SSSS SSSS | SSSS SSSS SSSS | SSSS SSSS SSSS SSSS 150 + SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS 120 + SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS 90 + SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS 60 + SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS 30 + SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS SSSS FFFF SSSS SSSS SSSS SSSS SSSS SSSS FFFF SSSS SSSS SSSS | SSSS SSSS SSSS SSSS SSSS SSSS SSSS FFFF FFFF FFFF IIII FFFF FFFF FFFF FFFF FFFF FFFF SSSS SSSS SSSS | FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF FFFF ------------------------------------------------------------------------------------------------------------------------- 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 HOUR Hour Of Day SYMBOL DEXSTATS SYMBOL DEXSTATS SYMBOL DEXSTATS SYMBOL DEXSTATS SYMBOL DEXSTATS E ERROR F FATAL I INFO S SUCCESS W WARNING





Figure 3-103. Process Terminations Status

Weekly Process Name Summary INQUIRY: DEXLW0 RUN DATE: 1AUG08 SYSID Proc Name Week Time CPU Direct Buffered Page Interval Week Prefix Zone Time I/Os I/Os Faults Time Date VMS2 BATCH 18 1 0:00:42.76 2,066 126 0 27:01:44.25 02MAY2008 18 2 0:01:11.06 3,392 206 958 44:47:37.82 01MAY2008 18 3 0:00:38.83 1,816 110 322 24:01:24.71 05MAY2008 19 1 0:01:08.12 3,297 201 323 43:17:44.47 06MAY2008 19 2 0:01:56.37 5,644 342 1,713 74:19:37.87 06MAY2008 19 3 0:01:00.96 2,879 175 643 38:02:13.85 05MAY2008 24 1 0:00:49.51 2,325 142 646 30:03:07.78 12JUN2008 24 2 0:01:23.99 3,979 243 998 52:04:14.31 11JUN2008 24 3 0:00:37.47 1,803 110 316 23:46:21.48 16JUN2008 25 1 0:03:27.44 5,386 1,863 9,110 45:03:07.91 17JUN2008 25 2 0:01:59.77 5,713 347 1,633 75:05:00.75 17JUN2008 25 3 0:01:16.69 3,645 222 640 48:02:50.14 16JUN2008 26 1 0:01:11.91 3,468 211 0 45:03:17.70 24JUN2008 26 2 0:04:17.78 7,937 1,979 9,059 74:50:04.98 24JUN2008 26 3 0:01:14.93 3,644 222 642 48:02:50.85 23JUN2008 27 2 0:00:00.39 18 1 0 0:15:00.85 01JUL2008 27 3 0:00:38.13 1,822 111 333 24:01:25.84 30JUN2008 ---- -------- -------------- ------------- ------------- ------------- --------------- VMS2 BATCH 0:23:36.11 58,834 6,611 27,336 717:47:45.56 VMS2 BLUNE 24 1 0:00:00.44 7 20 185 30:03:07.78 17JUN2008 24 2 0:00:00.00 0 0 0 52:04:14.31 17JUN2008 24 3 0:00:00.00 0 0 0 23:46:21.48 16JUN2008 25 1 0:00:00.00 0 0 0 45:03:07.91 20JUN2008 25 2 0:00:00.00 0 0 0 75:05:00.75 20JUN2008 25 3 0:00:00.00 0 0 0 48:02:50.14 23JUN2008 26 1 0:00:00.00 0 0 0 45:03:17.70 25JUN2008 26 2 0:00:01.98 11 103 136 74:50:04.98 25JUN2008 26 3 0:00:00.00 0 0 0 48:02:50.85 27JUN2008 27 2 0:00:00.00 0 0 0 0:15:00.85 01JUL2008 27 3 0:00:00.00 0 0 0 24:01:25.84 30JUN2008 ---- -------- -------------- ------------- ------------- ------------- --------------- VMS2 BLUNE 0:00:02.42 18 123 321 466:17:22.59 VMS2 CD9JE15 19 1 0:00:16.68 183 506 2,467 1:30:06.69 10MAY2008 19 2 0:00:25.49 289 1,737 4,155 2:00:08.10 09MAY2008 24 1 0:00:10.26 73 623 1,140 2:30:52.54 12JUN2008 26 1 0:00:05.77 68 235 787 0:15:01.03 27JUN2008 ---- -------- -------------- ------------- ------------- ------------- --------------- VMS2 CD9JE15 0:00:58.20 613 3,101 8,549 6:16:08.36

Figure 3-104. Weekly Process Name Summary

Weekly Process Activity INQUIRY: DEXLW1 RUN DATE: 1AUG08 SYSID = VMS2 Year = 08 Week = 25 Time Zone = 1 --------------------------------------------------------------------------------------------------------------------------------- Hour Process UIC CPU Direct Buffered Page Max Global Max Proc of Day Type Group Time I/O I/O Faults Pages Pages --------------------------------------------------------------------------------------------------------------------------------- 8 . 0:01:39.56 663 3,542 18,332 288 604 8 BATCH 200 0:00:07.83 367 20 0 212 760 8 DETACHED 1 0:00:05.97 0 0 0 404 487 8 INTERACT 1 0:00:00.00 0 0 0 72 144 8 INTERACT 200 0:00:00.00 0 0 0 78 245 --------------------------------------------------------------------------------------------------------------------------------- 0:01:53.36 1,030 3,562 18,332 --------------------------------------------------------------------------------------------------------------------------------- 9 . 0:01:42.70 664 3,664 18,375 288 604 9 BATCH 200 0:00:08.02 391 25 0 212 760 9 DETACHED 1 0:00:05.89 0 0 0 404 487 9 INTERACT 1 0:00:00.00 0 0 0 72 144 9 INTERACT 200 0:03:02.10 1,929 4,969 21,379 1,065 929 --------------------------------------------------------------------------------------------------------------------------------- 0:04:58.71 2,984 8,658 39,754 --------------------------------------------------------------------------------------------------------------------------------- 10 . 0:01:50.87 761 3,977 18,985 288 604 10 BATCH 200 0:02:12.43 2,170 1,507 7,273 212 1,143 10 DETACHED 1 0:00:17.75 52 630 0 404 487 10 INTERACT 1 0:00:00.00 0 0 0 72 144 10 INTERACT 200 0:02:29.55 1,478 6,021 25,376 161 608 --------------------------------------------------------------------------------------------------------------------------------- 0:06:50.60 4,461 12,135 51,634 --------------------------------------------------------------------------------------------------------------------------------- 11 . 0:01:55.86 1,217 3,829 18,324 288 604 11 BATCH 200 0:00:19.45 527 191 1,837 212 760 11 DETACHED 1 0:00:06.77 7 54 1 404 487 11 INTERACT 1 0:00:09.03 68 568 632 75 194 11 INTERACT 200 0:03:11.36 2,515 6,933 37,450 1,138 935 --------------------------------------------------------------------------------------------------------------------------------- 0:05:42.47 4,334 11,575 58,244 --------------------------------------------------------------------------------------------------------------------------------- 12 . 0:01:42.98 697 3,740 18,489 288 604 12 BATCH 200 0:00:07.89 394 25 0 212 760 12 DETACHED 1 0:00:13.48 30 390 0 404 487 12 INTERACT 1 0:00:00.00 0 0 0 72 144 12 INTERACT 200 0:01:10.19 605 1,685 6,140 125 259 --------------------------------------------------------------------------------------------------------------------------------- 0:03:14.54 1,726 5,840 24,629 ---------------------------------------------------------------------------------------------------------------------------------

Figure 3-105. Weekly Process Activity

Monthly Process Activity INQUIRY: DEXLM1 RUN DATE: 1AUG08 SYSID = VMS2 Year = 08 Month = 6 --------------------------------------------------------------------------------------------------------------------------------- Time Process UIC CPU Direct Buffered Page Max Global Max Proc Zone Type Group Time I/O I/O Faults Pages Pages --------------------------------------------------------------------------------------------------------------------------------- 1 . 0:43:34.46 18,109 84,287 383,115 397 604 1 BATCH 200 0:05:28.86 11,179 2,216 9,756 221 1,143 1 DETACHED 1 3:19:03.45 1,701 715,524 27,880 454 599 1 INTERACT 1 2:36:26.30 4,543 430,480 1,145,359 1,232 963 1 INTERACT 10 0:00:30.18 321 1,057 5,343 1,285 1,139 1 INTERACT 100 0:00:15.29 86 593 1,812 78 171 1 INTERACT 200 0:47:42.07 27,030 97,798 285,616 1,514 1,144 1 INTERACT 201 0:00:00.99 6 32 105 109 203 --------------------------------------------------------------------------------------------------------------------------------- 7:33:01.60 62,975 1,331,987 1,858,986 --------------------------------------------------------------------------------------------------------------------------------- 2 . 1:07:33.37 27,671 132,737 639,967 397 604 2 BATCH 200 0:07:41.54 17,629 2,569 11,690 221 1,151 2 DETACHED 1 1:35:25.74 1,304 345,351 10,822 454 599 2 INTERACT 1 0:58:40.68 250 164,727 438,472 127 226 2 INTERACT 100 0:00:22.81 581 716 870 76 139 2 INTERACT 200 0:38:18.06 25,250 82,759 133,033 1,367 1,105 2 INTERACT 201 0:00:09.75 90 274 1,220 112 200 --------------------------------------------------------------------------------------------------------------------------------- 4:28:11.95 72,775 729,133 1,236,074 --------------------------------------------------------------------------------------------------------------------------------- 3 . 0:49:37.98 21,104 104,195 490,049 395 698 3 BATCH 200 0:03:09.47 9,110 555 1,598 218 758 3 DETACHED 1 0:03:12.93 319 4,085 11 404 489 3 INTERACT 1 0:00:00.00 0 0 0 72 144 3 INTERACT 200 0:00:00.40 0 8 123 24 139 --------------------------------------------------------------------------------------------------------------------------------- 0:56:00.78 30,533 108,843 491,781 --------------------------------------------------------------------------------------------------------------------------------- 15:34:46.14 264,515 2,379,704 4,066,683 ---------------------------------------------------------------------------------------------------------------------------------


Figure 3-106. Monthly Process Activity

Tell Technical Publications how we can improve this information