Using the sample rule sets

BMC AMI DevOps for Db2

 provides the following sample rule sets:

Name

Description

$BMC SAMPLE RULE SET

Provides good examples of how to define rules. You can also use this sample rule set to verify successful installation. 

$BMC USRVARS SAMPLE RULE SET

Provides good examples of how to define rules with user-defined variables. The sample rule expressions are defined with the host variable equal to the user-defined variable.

You can use BMC AMI Command Center to view the contents of the sample rule sets. All of the views are read-only when viewing the sample rule sets. You can, however, make a full copy of the sample rule sets and copy a rule in a sample rule set to another rule set.

Important

The sample rules in the $BMC SAMPLE RULE SET and the $BMC USRVARS SAMPLE RULE SET might occasionally change when PTF maintenance is applied.

The topic contains the following procedures:

Related topics

Managing schema standards for SQL DDL statements

Managing schema rule sets

Viewing schema rule violations

Assuring SQL DML statement quality

Tuning SQL

Troubleshooting SQL statements

To view the sample rule set

  1. In the Product Tools perspective, select or add a Manage Schema Rules view.
  2. In the Manage Schema Rules view, select one of the following BMC sample rule sets:
    • $BMC SAMPLE RULE SET
    • $BMC USRVARS SAMPLE RULE SET
  3. Click Edit rule set NW_pencil_adapt.png. 
    The View rule set view is displayed. 

To copy the sample rule set

  1. In  the Product Tools perspective, select or add a Manage Schema Rules view.
  2. In the Manage Schema Rules view, select one of the following BMC sample rule sets:
    • $BMC SAMPLE RULE SET
    • $BMC USRVARS SAMPLE RULE SET
  3. Click Copy rule set NW_files_copy_o.png.
    The Copy rule set view is displayed.
  4. In the Copy rule set view, edit the default rule set name so the name is unique.
  5. Click Save changes NW_floppy.png.
  6. Click Back back_icon_app-24.png.

To copy a sample rule

  1. In the Product Tools perspective, select or add a Manage Schema Rules view.
  2. In the Manage Schema Rules view, select one of the following BMC sample rule sets:
    • $BMC SAMPLE RULE SET
    • $BMC USRVARS SAMPLE RULE SET
  3. Click Edit rule set NW_pencil_adapt.png.
    The View rule set view is displayed.
  4. Select a rule to copy.
  5. Click Copy rule NW_files_copy_o.png.
    The Copy Sample Rule dialog box is displayed.
  6. Select the Target rule set and click OK.
    The Copy rule view is displayed.
  7. Update the rule as needed.
    For more information, see Defining a schema rule.
  8. Click OK.
    The Edit rule set view for the target rule set is displayed. NG_plus_circle_dgreen.png is displayed next to the copied rule.
  9. Click Save changes NW_floppy.png.
  10. Click Back back_icon_app-24.png.

 

 

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