Analysis of BMC Software statistics
You can analyze statistics to determine the physical design of your Db2 structures and when to run maintenance utilities. Because the statistical profile of the objects can change, view the trends to determine what actions to take and when to take them.
DASD MANAGER PLUS timestamps BMCSTATS statistics and stores them in a separate database, and not in the Db2 catalog. DASD MANAGER PLUS provides two ways to view BMC Software statistics. You can display current and historic BMC Software statistics for the first, last, and previous time that the BMCSTATS utility was run. You can also browse BMC Software statistics beside Db2 catalog statistics to compare the values. (See Browsing-and-updating-statistics.) The additional statistics that BMCSTATS collects are useful in determining when to schedule maintenance utilities.
If your terminal supports IBM GDDM graphics, you can analyze trends in Db2 objects by displaying 18 graphs of statistical relationships for all of the data in the historical database. You can tailor graphs while viewing them to focus on specific trends. You can also generate hard-copy reports.
Because the statistics database is in DB2 tables, you can use a query facility to report on Db2 statistics and produce trend reports. DASD MANAGER PLUS provides many reports and sample QMF queries that you can run against the historical database and that let you produce trend analysis reports.