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.

Running the BMCSTATS utility

Use this procedure to run the BMCSTATS utility to populate the DASD MANAGER PLUS database with statistics. This procedure uses the ASUTSYST sample JCL. The procedure collects current statistics for evaluation by BMCTRIG.

  1. Modify the members to include the Db2 and DASD MANAGER PLUS data set names that are installed at your site.
  2. Modify the jobcard to meet your installation standards.
  3. Change the parameters for ASUSMAIN to name your Db2 subsystem and the DASD MANAGER PLUS installation options module.

  4. If you do not want to run against all objects on the subsystem at once, change the %.% pattern in the SYSIN DD syntax to limit the selected objects.

    Important

    If there are more than 100,000 objects or partitions exist in your subsystem, BMC recommends not using %.%.

    Alternatively, you can define object sets if you require more complex selection criteria at your site. You can also use the sample SQL in ASUINSOS to create an object set, PUBLIC.RTS_STATS, that examines the DB2 RTS tables for objects that need statistics taken. For more information about creating object sets, see Using-object-sets.

    For more information about setting up BMCSTATS jobs, see Updating-the-Db2-catalog-by-using-BMCSTATS.

Related topics

Using

Example-of-utility-automation

 

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