Category Archives: Performance Management

How to create a IBM Spectrum Control Performance Support Package

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).

sc-cpsp1

Right mouse click on any Block Storage System and select Create Performance Support Package.

sc-cpsp2

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.

sc-cpsp3

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.

sc-cpsp4

You will briefly see the following window before getting the download prompt.  Click close when you see this again.

sc-cpsp5

sc-cpsp6

Download the zip file and if you extract it you will see the following.

sc-cpsp7

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.

https://ibm.box.com/s/vtecjzujfa6tn9gqjx4aq1ejr9c2mihl

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.

sc-cpsp8

Enjoy!

– Dominic

 

Advertisements

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).

exportPerformanceData Windows Location

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).

exportPerformanceData SC BlockStorage Listing

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.

http://www.ibm.com/support/knowledgecenter/SS5R93_5.2.9/com.ibm.spectrum.sc.doc/ref_per_export_perf_data_script.html?lang=en

exportPerformanceData ClassSVC Export Run

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

exportPerformanceData ClassSVC Export Output

To view the different Storage System data generated from this script just click the link below.

https://ibm.box.com/s/q09chpp6d8ne8xqpiqnbfk5i7lmu2360

Enjoy!