Setting up BMC AMI Utility Management


This topic describes how to set up the BMC AMI Utility Manager for Db2. The BMC AMI Utility Manager uses the IBM Db2 Real Time Statistics (RTS) facility and user-defined criteria to identify which database objects need to be processed by the BMC AMI Utilities utility products, and under what conditions.

BMC AMI Utility Manager processes table spaces and indexes according to values contained in the BMC AMI Utility Manager tables, which are installed during the installation of any BMC AMI Utilities utility:

BMC AMI Utility Manager tables

Table

Description

Criteria table

Defines the criteria for selecting Db2 objects for processing

Exceptions table

Defines deviations from regular processing (for example, preventing reorganization during ad hoc maintenance)

Schedules table

Defines periodic processing conditions (for example, preventing reorganization on the specified day of the month)

Durations table


Defines how long a BMC AMI Utility Manager job is allowed to run

Using BMC AMI Command Center, you can specify values in each of these tables for groups of indexes, table spaces, and applications.

You can edit multiple criteria, exceptions, and schedule values before you save all the changes to the BMC AMI Utility Management view in one action.

After setting up BMC AMI Utility Manager, you activate it by including the RTS keyword in the SYSIN command of an BMC AMI Utilities utility product.

Example
//SYSIN DD *
COPY TABLESPACE CENTRAL.ACCTGREC RTS


For more information, see the BMC AMI Utility Manager for Db2 documentation.

The following pages provide information about how to set up BMC AMI Utility Management:

 

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