A new version of the DB2 Analytics Accelerator toolkit is available. One new tool for estimating HPSS savings has been added. The tool queries the DB2 catalog (RTS and SYSCOPY) to find partitions that have not changed in a certain amount of time. You have the ability to specify how long they must not have changed for. You have the ability to include or exclude tables that are parents in RI (as the RI would have to be dropped to be able to archive). Once the tool finds partitions that have not changed, it looks to see how much DASD each of those partitions is using. It then finds all the associated indexes and estimates the indexspace reduction that would accompany archival of the tablespace partitions. The output of the tool is a report that shows you how much DASD could be saved. The information is summarized in several different ways, including for the whole subsystem, by schema, and by table. You also have the ability to enter a dollar amount for DASD in $/GB. The report will show both the amount of DASD that could be saved in GB/TB and the corresponding dollar amount.
Great news! YOU CAN USE THIS TOOL EVEN IF YOU DON'T HAVE A DB2 ANALYTICS ACCELERATOR TODAY!
To run the tool, from a Windows command prompt (cmd), go to the directory where you saved the IDAATools.jar file and run...
java -classpath IDAATools.jar EstimateHPSSSavings
From there just follow the prompts.
This new piece of the toolkit is provided under the same terms as the rest of the toolkit, which can be found in the original toolkit blog post. The bottom line is that the code is provided as-is, with no support or warranty. I am, however, happy to help out if you have any problems, and am always interested in feedback.
IDAAToolsSource.jarView DetailsIDAATools.jarView Details