Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

Browsing and updating statistics

You can use DASD MANAGER PLUS to browse and update Db2 catalog statistics that influence the Db2 Optimizer. You can also compare Db2 catalog statistics with BMCSTATS statistics.

The browse function displays Db2 catalog and BMCSTATS or other statistics on the same panel. You can use this feature to compare sets of statistics for table spaces, indexes, and tables. Analyzing-statistical-trends describes the display function for viewing BMCSTATS statistics.

Important

You must update the DASD MANAGER PLUS historical database with the BMCSTATS utility at least once before you can compare Db2 catalog statistics with statistics that BMCSTATS produces.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*