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


The following table lists the tables used by BMC AMI DevOps Schema Mgmt for Db2 - Schema Standards and BMC AMI SQL Assurance for Db2:

Table name

Description

AMA_RULES

Rule definitions that are tied back to a Rule set

AMA_RULESETS

Groups of Rules

AMA_RULESET_DEP

Reference links between a primary Rule set and other Rule sets

AMA_RULESET_VARS

For future use

AMA_RULE_CONDITIONS

Rule expression and When clauses

AMA_RULE_PICK_LIST

Internal data repository

AMA_RULE_PICK_VAL

For future use

AMA_VIOLATIONS_LOG

Schema and SQL statement violations

AMA_VIOLATIONS_SQLTEXT

SQL text for SQL statement violations

AMA_VIOLATIONS_TO_IGNORE

Rules that ignore violations found within schema and SQL statements

AMA_WORKID_IMPACT

Impact of the WorkID analyzed

AMA_WORKID_IMPACT_OBJ

List of objects within a WorkID that will have certain utilities run against them

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*