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.

Managing Db2 and BMC Software statistics

You can use 

DASD MANAGER PLUS

 to update Db2 catalog statistics for table spaces, indexes, and tables.

You can update these statistics interactively or by using a batch utility job. You can use the interactive update function to compare and update the Db2 catalog with the most recent BMCSTATS or other statistical values that you choose. For example, you can update the Db2 catalog statistics with values from the DASD MANAGER PLUS statistics tables by using the DASD MANAGER PLUS update panels or in batch by using the BMCSTATS and BMCUPRS utilities.

Important

(BMC.DB2.SPE2210)  DSNDB01 support is limited to BMCSTATS. BMCSTATS does not update Db2 catalog tables for DSNDB01 objects. BMCSTATS collects only space-related statistics for DSNDB01. BMCCPRS and BMCUPRS does not support DSNDB01 objects. 

Using BMCSTATS, you can choose to continue statistics without updating the Db2 catalog and without affecting the Db2 Optimizer path selection. Alternatively, you can update the DASD MANAGER PLUS database with values from the Db2 catalog by using BMCCPRS.

Important

If you set the UPDNUCAT option in the installation options module to N, BMCSTATS updates only the Db2 catalog fields that allow SQL update. If you set this option to Y, BMCSTATS updates all statistics columns.

You can also delete object statistics that are no longer useful. You can automatically delete BMCSTATS statistics when you collect new statistics or manually delete them by using the user interface.

Related topics

 

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