Default language.

Limited supportBMC 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 Utility Manager for Db2 13.1.

Managing BMC AMI Utility Manager tables

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

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 (BMC.DB2.SPE2110)

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 that are currently registered in the checkpoint data set.

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 table definitions for all Db2 subsystems in the checkpoint. Omitting ALL displays definitions for the current Db2 subsystem only.

Deleting BMC AMI Utility Manager tables

Deleting the BMC AMI Utility Manager tables is rarely needed. However, if necessary, you can use the DELETE statement to remove the registered BMC AMI Utility Manager schema from the BMC AMI Utilities checkpoint data set.

Important

DELETE does not remove the schema from the Db2 catalog.

Related topic

Using

 

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