I’ve been asked more than several times now on how to extract storage performance data for modeling and analysis. Here is the process available (on current levels of the product) to download storage performance data from the main web based user interface for IBM Spectrum Control.
First login and get to the Block Storage Systems window (both Monitor and Administrator IDs can do this).
Right mouse click on any Block Storage System and select Create Performance Support Package.
The default time window is the last 8 hours, so change it to the time range you would like to download (I changed it to the last 12 hours). Check “Advanced package”, to get additional data at 1 minute intervals (if available) and additional data on volumes. Then select the Next button.
You will then be prompted to create and download the package. This window will give you the file size and time range covered. Click the Create button to download a compressed zip file.
You will briefly see the following window before getting the download prompt. Click close when you see this again.
Download the zip file and if you extract it you will see the following.
If you would like to take a look at these files (and all the interesting data columns in each one), you can click this link to see the public folder where this data is.
If you would like to try this yourself, you can use the public IBM Spectrum Control Storage Insights demo site. Just login with your IBMid, click on Resources -> Block Storage Systems and follow the steps above.
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.
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.