Deleting BMC Software statistics


Use this procedure to delete individual, outdated BMC Software object statistics from the 

DASD MANAGER PLUS

 database.

Important

You can also delete groups of statistics according to their age by using the BMCSTATS DeleteAge option.

To delete BMC Software statistics

  1. Create a list of Db2 objects that contains the object whose statistics you want to delete.If necessary, follow the instructions in Creating a Db2 object list.

    The Display Db2 Object List appears.

  2. To display the BMC Software Statistics for the object, type D in the Act field beside the object name and press Enter.See Analyzing-statistical-trends.

    The statistics panel for the specify object appears.

  3. List the BMC Software statistics detail by typing S in the Display Entry List field at the bottom of the panel and pressing Enter.

    Important

    You can also list entries by typing L at the COMMAND line and pressing Enter.

    The statistics list panel for the object appears.

  4. Type D in the Act field beside the statistic to delete and press Enter.The Delete objectType Statistics panel appears. Use this panel to confirm your selection.
  5. On the Delete objectType Statistics panel, you can delete the specific entry by typing E in the Delete Oper field, or you can delete all entries older than the Delete Date you chose by typing L in the Delete Oper field.Eliminating all old entries means that you do not need to remove each entry separately from the BMCSTATS tables.
  6. Press Enter to delete the statistics or END to return to the previous panel without deleting statistics.

    Important

    We provide sample SQL in the HLQ.CNTL (ASURSDEL) data set that can help you delete the objects from the BMCSTATS tables that no longer exist in the catalog.

 

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