Managing schema standards for SQL DDL statements

Using the Schema Standards feature, you can ensure adherence to schema standards for SQL DDL statements that are used to create and maintain your Db2 objects.

Validating schema

Using the BMC AMI DevOps for Db2 Schema Standards step, you can submit proposed schema for validation. BMC AMI DevOps validates the schema against schema rules that you create for your site. The validation process logs any violations of the schema rules for review by application developers and database administrators. If the validation process encounters a violation, the process checks to see if an exception to the schema rule (Violation to Ignore rule) exists.

For more information, see BMC AMI DevOps for Db2 documentation.

Managing schema rules

Using the Schema Standards Rules view, you can create the rule sets needed to validate schema. Rule sets consist of one or more rules and links to other rule sets. You need to make at least one rule set to validate your schema.

You can use the Schema Standards Rules view to:

• Add, change, and delete rule sets
• Maintain the rules in a rule set
• Copy a rule set
• Rename a rule set
• Combine rules into rule sets
• Deploy rule sets to Db2 subsystems where they are needed

For more information, see Managing-schema-rule-sets and Deploying-schema-rule-sets.

Managing schema rule violations

The validation process logs violations of schema rules while analyzing the schema changes. The validation process logs each violation as a warning or error depending on the rule and rule set definition. If a violation to ignore rule exists, the validation process allows the violation to pass.

Viewing schema rule violations

You can use the Schema Standards Violations view to:

• Review a summary of schema rule violations by Db2 subsystem
• Review a detailed list of schema rule violations for a Db2 subsystem
• Create an instant violation to ignore rule for a specific DDL statement
• Access the Manage Violations to Ignore rules view

For more information, see Viewing-schema-rule-violations.

Managing VTI rules

You can use the Manage Violations to Ignore (VTI) rules view to:

• Add new rules
• Edit existing rules
• Remove unwanted rules
• Copy a rule
• Deploy rules to Db2 subsystems where they are needed

For more information, see Managing-Schema-Standards-VTI-rules and Deploying-Schema-Standards-VTI-rules.