BMC AMI DevOps repository tables

The Db2 repository objects support both the Schema Standards and SQL Assurance solution features. The BMC AMI DevOps repository objects need to exist on each Db2 subsystem where these solution's features will be run. The default database, table, and index creator name is BMCAMA. The Db2 repository database objects are created when the following solutions are installed:

BMC AMI DevOps solution - component

Backend mainframe product

BMC AMI DevOps Schema Mgmt for Db2 – Schema Standards

BMC AMI Change Manager for Db2

BMC AMI SQL Assurance for Db2

BMC AMI SQL Explorer for Db2


Some content is unavailable due to permissions.

Repository table maintenance

You are responsible for maintaining the tables that are used by BMC AMI DevOps Schema Mgmt for Db2 – Schema Standards and BMC AMI SQL Assurance for Db2.

In addition to installing the tables, maintenance tasks for the tables include:

  • Sizing the tables to accommodate growth requirements
  • Purging the tables of old or unnecessary data
  • Reorganizing the tables to improve performance
  • Backing up for recovery

For more information about the administrative tasks associated with managing the application databases, see the IBM documentation.

 

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