How can I generate the memory utilization graph and save it in CSV format?
Article ID: 13880
Updated On:
Products
Issue/Introduction
The memory utilization graph is one of the standard graphs that is available in CA Performance Management for OpenVMS. The graph can be generated and plotted by specifying the keyword "MEMORY_UTILIZATION" as the value of the /TYPE qualifier on the ADVISE PERFORMANCE GRAPH DCL command or by selecting it in the Performance Manager graphical user interface.
How can I generate the memory utilization graph so that it is stored as a file in comma-separated value (CSV) format for use with other tools such as Microsoft Excel?
Environment
Resolution
To generate the memory utilization graph in CSV format and save it to a file, use the /FORMAT and /OUTPUT qualifiers on the ADVISE PERFORMANCE GRAPH command. The example below will produce the memory utilization graph in CSV format using performance data collected from the host named MYIA64 between the hours of 8:00AM and 5:30PM on Monday, March 20th, 2017. The output will be saved to the file named 20MAR_MEM_UTILIZATION.CSV.
$ ADVISE PERFORMANCE GRAPH -
/TYPE=MEMORY_UTILIZATION -
/FORMAT=CSV -
/OUTPUT=20MAR_MEM_UTILIZATION.CSV -
/BEG=20-MAR-2017:08:00/END=20-MAR-2017:17:30:00 -
/NODE=MYIA64
Additional Information
Use the /NOSTACK command qualifier to override the stacking of the memory utilization categories. By default, category values are stacked and added from right to left whereas specifying the /NOSTACK command qualifier will cause each category value to be output separately.
Specify the X_POINTS=<integer value> option after the CSV keyword to affect the number of points along the X axis. For example, smaller values results in smoother data whereas larger values will result in peaks and valleys being defined. By default, the graphing facility will pick a "best-fit" based on the time frame of the selected performance data. The minimum and maximum values of X_POINTS are 2 and 480, respectively. Examples of using X_POINTS are below:
/FORMAT=CSV=X_POINTS=20 - results in a smoother data (peaks and valleys are not well defined when plotted)
/FORMAT=CSV=X_POINTS=480 - results in more granular data (peaks and valleys are well defined when plotted)
Feedback
