Managing BMC AMI Utility Manager tables

This topic contains the following procedures for managing BMC AMI Utility Manager tables.

Related topic

Using

Before you begin

To evaluate objects, BMC AMI Utility Manager requires the following tables. The product creates these tables when you install it, but you can edit them, as needed.

Table

Description

Exceptions table

Defines exceptions to standard processing schedules

The values in these columns tell BMC AMI Utility Manager whether to:

  • Exclude objects from processing
  • Force processing
  • Ignore the Exceptions record for the specified utility
Example

If the Exceptions record applies to BMC AMI Reorg, BMC AMI Utility Manager ignores the Exceptions record for BMC AMI Stats and BMC AMI Copy.

If planning to implement application changes, you can edit the Exceptions table to prevent BMC AMI Reorg from reorganizing objects on a specified day.

Criteria table

Lists sets of table spaces or indexes to evaluate

BMC AMI Utility Manager refers to fields in the Criteria table to determine whether to perform specified actions.

Schedule table

Sets the normal processing time frame

Use this table to avoid reorganizations on a particular day of the month, week, or time frame.

Duration table 

The Duration table contains duration records that specify how long a BMC AMI Utility Manager job is allowed to run. If the job duration exceeds, BMC AMI Utility Manager does not start processing other objects. Objects that are already in process continue processing until completed.


Editing BMC AMI Utility Manager tables

The BMC AMI Utility Manager tables are standard IBM Db2 tables. To edit the tables, use either of the following methods:

  • (recommended) BMC AMI Command Center for Db2 graphical user interface (GUI), if available

    For more information, see the BMC AMI Command Center for Db2 documentation or BMC AMI Command Center for Db2 online Help.

    Important

    BMC AMI Command Center for Db2 is available only as part of specific BMC solutions for Db2. It is not available as a stand-alone product.

  • Standard SQL statements
  • Table editor available with the BMC AMI Catalog Manager for Db2 product

Displaying BMC AMI Utility Manager table definitions

Use the following procedure to view the BMC AMI Utility Manager table definitions:

Enter a SYSIN DD statement that includes an NGTRTS DISPLAY statement, using the following syntax:

//NGT EXEC PGM=NGTUTIL,PARM='<ssid>,,NORESTART
//UTPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSIN DD *
NGTRTS DISPLAY ALL

Include ALL if you want to see the alias and table information for the BMC AMI Utility Manager tables.

 

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