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.