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.

Altering, renaming, or dropping and re-creating objects

When you alter or drop and then re-create an object (for example, if you change the keys of an index, or drop partitions from a table space), BMCSTATS statistics remain in the BMC Statistical Repository for these objects until you delete them.

To ensure that your statistics accurately reflect the objects in your database, use one of the following methods to delete obsolete statistics:

  • Run BMCSTATS on the altered or dropped object with DELETEAGE set to 0 to delete all statistics relating to the dropped object. For more information, see BMCSTATS-repositories.
  • Delete individual statistics through the online interface by following the procedure described in in Deleting-BMC-Software-statistics.
  • Manually alter and run the sample SQL that BMC provides in the HLQ.CNTL (ASURSDEL) data set.

For more information on managing DASD MANAGER PLUS repositories, see DASD-MANAGER-PLUS-repositories-management.

 

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