Overview of BMC AMI Utility Manager

BMC AMI Utility Manager for Db2 (BMC AMI Utility Manager) helps you determine—from within a BMC AMI Utility—whether to run the utility against your database objects, based on real-time statistics.

BMC AMI Utility Manager maximizes application performance and saves resources by:

  • Enabling frequent reorganization executions (because the product can select fewer—or no—objects for processing)
  • Reorganizing only objects that match your reorganization criteria, thus preventing unnecessary reorganizations

Related topic

Getting-started-with-BMC-AMI-Utility-Manager

BMC AMI Utility Manager uses criteria that you specify and IBM Db2 runtime statistics (RTS) to identify database objects that require processing.

BMC AMI Utility Manager identifies the table spaces and indexes for:

  • Copying with BMC AMI Copy for Db2  (BMC AMI Copy) 
  • Reorganizing with BMC AMI Reorg for Db2 (BMC AMI Reorg) 
  • Collecting statistics with BMC AMI Stats for Db2 (BMC AMI Stats) 

Then, depending on the options that you select, BMC AMI Utility Manager take one of the following actions:

  • Identifies and reports the objects that require processing—but without actually processing them
  • Identifies objects that require processing and runs the appropriate BMC AMI Utility to process the identified objects

Important

To invoke BMC AMI Utility Manager from the BMC AMI Copy product, you must invoke NGTUTIL—not ACPMAIN—to drive your copies.

After setting up BMC AMI Utility Manager, you can activate it by including an RTS keyword in your utility product's SYSIN statement.

In the following example, the RTS keyword invokes BMC AMI Utility Manager to use real-time statistics to determine whether BMC AMI Reorg should reorganize table space CENTRAL.%:

Example
//SYSIN DD *
REORG TABLESPACE CENTRAL.% RTS

Benefits

Using BMC AMI Utility Manager to evaluate the objects before you process them offers the following advantages:

  • You can specify separate evaluation criteria for each object, or groups of objects.
  • BMC AMI Utility Manager can recommend an index for reorganization even if the corresponding table space does not require reorganization.
  • BMC AMI Utility Manager can trigger a reorganization even if the product has not initialized reorganization values in RTS.
  • You can use WHERE clauses to specify custom criteria or conditions.
  • You can use the Schedule table to fine-tune when to run BMC AMI Utilities (for example, by forcing or preventing reorganizations for a particular day of the week, date, or date range).
  • You can use the Exceptions table to force or prevent reorganizations that deviate from the schedule defined in the Schedule table records.

 

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