This is just a quick note to put some information out here to see if it helps you to more easily create charts from the Resusage data.
Much of the information you should be tracking comes from DBC.ResUsageSPMA, and that is what this process is going to analyze. Note that this process is for TD12 only.
The first file to look at is HigaTD12.btq. This is the file that you will run via BTEQ to pull the data to prepare for charting.
Edit this file and replace the logon string with the appropriate information for your site.
This file is going to pull data for the past 30 days. You can adjust that at the bottom if you wish.
This file assumes there is no pma.out file in the directory from which you are running this. So, DELETE pma.out first! (Yes, I know I could change the script to do the delete for you. But, I don't want to be responsible for deleting anything from your computer! So, you can add that yourself if you wish. Something like ".OS del pma.out"
Once you are ready, then execute the script via BTEQ by using something like this command from a Windows Command Prompt: bteq < HigaTD12.btq > Higaquery.log
If this was successful, you will have a non-blank pma.out file in the directory from which you ran bteq.
Now you can open the excel spreadsheet entitled MakeChartsRelTD12.1.4.xls. When you open this chart, you will be asked about enabling macros and you want to answer YES.
Next click on the START button, and you will be asked to navigate to the directory that contains your pma.out file. Select that file, and the spreadsheet should automatically create all of the charts for you.
Please let me know of your experiences with this process. Is it working for you? Are you having problems?
Perhaps in a future blog I will provide some basic "things to look for" in these charts.