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.

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. For information about which products can operate concurrently, see the DASD MANAGER PLUS for DB2 Reference Manual.

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.

Related Topics




 

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