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
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!
A new version of IBM Spectrum Control became generally available at the end of February.
All the new features and functions are on the IBM Knowledge Center website .., of particular note is the new Storage Reclamation function so Storage Administrators can reclaim/repurpose unused storage. Click on this link to read about all the new changes.
http://www.ibm.com/support/knowledgecenter/SS5R93_5.2.9/com.ibm.spectrum.sc.doc/prd_whats_new.html
