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.

Related topics

Having-authority-to-collect-statistics

Updating-Db2-columns-by-DASD-MANAGER-PLUS

Updating-Db2-real-time-statistics

Updating-the-Db2-catalog-by-using-BMCSTATS

Updating-the-Db2-catalog-by-using-BMCUPRS

Updating-DASD-MANAGER-PLUS-statistics-by-using-BMCCPRS

Altering-renaming-or-dropping-and-re-creating-objects

Deleting-BMC-Software-statistics

Displaying-Db2-object-lists

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.

 

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