Collecting, viewing, and managing statistics

The DASD MANAGER PLUS product provides a set of statistics tools. These tools maximize your ability to administer Db2 objects by performing the following tasks:

  • Providing a historical database
  • Collecting statistics
  • Updating the Db2 catalog statistics
  • Viewing statistics
  • Setting threshold values and actions
  • Estimating space requirements

DASD MANAGER PLUS can collect statistics while the objects are in use and allow you to view the statistics interactively, as text or in graphs.

Important

Some BMC utilities can operate concurrently on the same object or partition.

Related Topics

Quick-reference-of-statistics-related-tasks

Tips-for-collecting-statistics

Collecting-statistics

Sampling-statistics

Accessing-the-statistics-display-features

Browsing-and-updating-statistics

Managing-Db2-and-BMC-Software-statistics

DASD MANAGER PLUS also provides the following utilities for managing statistics:

  • BMCSTATS allows you to monitor growth patterns and other changes through a historical database of statistics.
  • BMCTRIG (discussed in Analyzing objects by using BMCTRIG) provides these capabilities:
    • Allows you to set exception values
    • Scans the historical database to determine whether the exception values have been reached
    • Generates JCL for utilities and commands to address objects when the exception values are reached

You should run BMCSTATS to collect statistics before you try to use the statistics display, update, and management tasks that this section describes. For more information, see Updating the Db2 catalog by using BMCSTATS.

Important

After upgrading to a new version of DASD MANAGER PLUS, you must run BMCSTATS on Db2 objects to populate the newly added columns.

A Db2 object list initiates the statistics display, update, and space estimation tasks. If you are not familiar with creating object lists in DASD MANAGER PLUS, see Creating a Db2 object list.

Other statistics tasks in this section use Service Actions. If you are not familiar with Service Actions, see Maintaining and generating Service Actions.




 

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