This blog post has been moved to the following page which will be frequently updated:
https://storagemvp.wordpress.com/historical-whats-new-for-ibm-spectrum-control
How to extract storage performance data using TPC v5.2.7 batch reports and stand alone gui
I’ve been asked more than a couple times on how one pulls storage performance data from TPC using batch reports. Here is a video that details this using TPC v5.2.7 and a box directory with the output from the video. Enjoy!
Files from this video.
https://ibm.box.com/s/mkq1ytwmfkol2l0c7a5fcmqs2tzuqgut
How to use the exportPerformanceData script in IBM Spectrum Control
A little known but powerful performance data extraction script was added to IBM Spectrum Control in the last couple releases (starting with Spectrum Control v5.2.8), it’s called exportPerformanceData.bat (on Windows) or exportPerformanceData.sh (on AIX & Linux).
This script resides ON the Spectrum Control server (in the same location as the other scripts to turn on and off servers) and is run local to the server (or could be redirected to other Spectrum Control servers).
You will need your Spectrum Control storage friendly name for the device name in the script (this was not too clear, and you need to account for spaces too by using quotes).
After opening a command prompt and changing to the directory where the script is, I selected my Class SVC to export performance data. There are many other options as you can see below, but one can perform a simple export of all Class SVC performance metrics with just a Spectrum Control ID, PW, and Storage as parameters.
A full explanation is in the IBM Knowledge Center for Spectrum Control, here is a link.
By default, a new sub-directory was created where I ran the script and the CSV files were put there. This directory was eventually compressed in to a file called Class SVC.zip
To view the different Storage System data generated from this script just click the link below.
https://ibm.box.com/s/q09chpp6d8ne8xqpiqnbfk5i7lmu2360
Enjoy!
