Limited support BMC 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 BMC AMI Command Center for Db2 13.2

Managing the BMC AMI Utility Management criteria settings


You can set utility processing criteria for groups of table spaces, indexes, and applications. Use the following procedures to to add, edit, or delete criteria from the Criteria table.

To add criteria

New console


  1. In the Product Tools perspective, select or add a BMC AMI Utility Management view.  
  2. In the Criteria tab, click Add Criteria NW_plus_circle_o.png
  3. In the General tab of the Add BMC AMI Management Criteria dialog box, complete the following fields:


    Field

    Description

    Type

    Select one of the following types:

    • Applications
    • Table spaces
    • Indexes

    Name pattern

    Enter a name pattern that matches the object type that you selected. You can use the * or % wildcard, or both.

    Partition

    Enter a partition number or specify 0 for all partitions.

    Comment

    Enter a comment describing the criteria.

  4. According to the object type that you want to define, select the Table Space Criteria tab or the Index Criteria tab. If you want to define values for an application, you can define values in both tabs.The tab lists trigger criteria, grouped by utility (BMC AMI Reorg triggers, BMC AMI Copy triggers, and BMC AMI Stats triggers).
  5. Edit any trigger criteria values that you want to change.

    Tip

    Hovering over a trigger criteria name lets you view a description.

  6. ( Optional ) If you want to add or edit a trigger on a WHERE clause, enter a valid WHERE clause.BMC AMI Utility Manager uses the BMC AMI Utilities SQL language for WHERE clauses. For more information, see BMC-AMI-Utilities-SQL-language.

    Important

    BMC AMI Command Center does not validate the WHERE clause.

  7. Click OK.
    NW_plus_circle_green.png is displayed next to each added criterion.
  8. Click Save Changes NW_floppy.png to save all the changes to the BMC AMI Utility Management view
Classic console
  1. In the Product Tools perspective, select or add an NGT Utility Management view.  
  2. In the Criteria tab, click Add Criteria Add-16.png

    Tip

    You can also right-click in the table to select this action.

  3. In the General tab of the  Add NGT Management Criteria dialog box, complete the following fields:


    Field

    Description

    Type

    Select one of the following types:

    • Applications
    • Table spaces
    • Indexes

    Name pattern

    Enter a name pattern that matches the object type that you selected. You can use the * or % wildcard, or both.

    Partition

    Enter a partition number or specify 0 for all partitions.

    Comment

    Enter a comment describing the criteria.

  4. According to the object type that you want to define, select the Table Space Criteria tab or the Index criteria tab. If you want to define values for an application, you can define values in both tabs.The tab lists trigger criteria, grouped by utility (BMC AMI Reorg triggers, BMC AMI Copy triggers, and BMC AMI Stats triggers).
  5. Edit any trigger criteria values that you want to change.

    Tip

    Hovering over a trigger criteria name lets you view a description.

  6. ( Optional ) If you want to add or edit a trigger on a WHERE clause, enter a valid WHERE clause.BMC AMI Utility Manager uses the NGT SQL language for WHERE clauses. For more information, see BMC-AMI-Utilities-SQL-language.

    Note

    BMC AMI Command Center does not validate the WHERE clause.

  7. Click OK.
  8. Click g_gud_save.png to save all the changes to the NGT Utility Management view.

To edit criteria

You can edit multiple criteria, exceptions, schedules and (BMC.DB2.SPE2201) durations before you save all the changes to the BMC AMI Utility Management view in one action.

New console
  1. In the Product Tools perspective, select a BMC AMI Utility Management view.
  2. In the Criteria table, select an criterion that you want to edit and click Edit criteria NW_pencil_adapt.png .
    The criteria that you are editing is displayed at the top of the dialog box. 
  3. In the Edit BMC AMI Utility Management Criteria dialog box, edit the values in the General, Table Space Criterion and Index Space Criterion tabs.
  4. (Optional) Edit additional criteria using the Previous criteria NW_arrow_up_circle.png and Next criteria NW_arrow_down_circle.png arrows to navigate to another criteria.
  5. When you have completed your edits, click OK
     NW_pencil_adapt_teal.png  is displayed next to each edited criterion.
  6. Verify the edited criteria, you can reset the changes, by selecting one or more edited criteria and clicking  NW_refresh.png .
  7. (Optional) You can now edit the Exceptions, Schedules, and Durations settings.
  8. Click Save Changes NW_floppy.png  to save all the changes to the BMC AMI Utility Management view.


    Important

    Next time that you select an edited criterion, the Last update field will show the user ID and timestamp of the last update to the criterion.

Classic console
  1. In the Product Tools perspective, select an NGT Utility Management view.
  2. In the Criteria table, select an criterion that you want to edit and click Edit criteria edit-24.png .
    The criteria that you are editing is displayed at the top of the dialog box. 
  3. In the Edit Utility Management Criteria dialog box, edit the values in the General, Table Space Criterion and Index Space Criterion tabs.
  4. (Optional) Edit additional criteria using the Previous criteria MoveUp-16.png and Next criteria MoveDown-16.png arrows to navigate to another criteria.
  5. When you have completed your edits, click OK
     edit-24.png  is displayed next to each edited criterion.
  6. Verify the edited criteria, you can reset the changes, by selecting one or more edited criteria and clicking  reset-24.png .
  7. (Optional) You can now edit the Exceptions and Schedules settings.
  8. Click  g_gud_save.png  to save all the changes to the NGT Utility Management view.


    Note

    Next time that you select an edited criterion, the Last update field will show the user ID and timestamp of the last update to the criterion.

To delete criteria

New console
  1. In the Product Tools perspective, select a BMC AMI Utility Management view.
  2. In the Criteria table, select one or more criteria for deletion.
  3. Click Delete criteria NW_minus_circle.png.
    NW_minus_circle_red.png is displayed next to each criterion that you selected to delete.
  4. Verify the criteria that you selected to delete, you can undo the deletions, by selecting one or more selected criteria and clicking NW_refresh.png.
  5. Click Save Changes NW_floppy.png to save all the changes to the BMC AMI Utility Management view.
Classic console
  1. In the Product Tools perspective, select an NGT Utility Management view.
  2. In the Criteria table, select one or more criteria for deletion.
  3. Click Delete criteria Delete-16.png.
    Delete-16.png is displayed next to each criterion that you selected to delete.
  4. Verify the criteria that you selected to delete, you can undo the deletions, by selecting one or more selected criteria and clicking reset-24.png.
  5. Click g_gud_save.png to save all the changes to the NGT Utility Management view.


 

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