Managing schema rule sets

The Manage Schema Rules view displays the schema rule sets for a Db2 subsystem. From this view, you can maintain schema rule sets and rules for your organization.

This topic contains the following procedures:

To add a Manage Schema Rules view

  1. Open or create a workspace.

  2. In the Product Tools perspective, click the Add View NW_plus_circle_o.png menu arrow, and then click Add Schema Standards Rules view.

    Tip

    The default value of the Add View menu is always the last option that you created.

    The Add Schema Standards Rules View dialog box is displayed.

  3. In the Add Schema Standards Rules View dialog box, select a DB2 Connection and then click OK.
    The Manage Schema Rules view displays the rule sets defined for your site. It also displays the sample rule set provided by BMC.
  4. Click Save Workspace NW_floppy_orange.png to save the changes to the workspace.

To add a schema rule set

  1. In the Product Tools perspective, select or add a Manage Schema Rules view.
  2. Click Add rule set  NW_plus_circle_o.png. 
  3. In the Add rule set view, enter a name for the rule set.
  4. To add a rule, follow these steps:
    1. On the Rules tab, click Add rule NW_plus_circle_o.png.
      The Add rule view is displayed. 
    2. Enter the rule definition. For more information, see Defining-a-schema-rule.
    3. Click OK.
      NW_plus_circle_green.png is displayed next to each added rule. Repeat steps a through c until all rules are added.
  5. To add related rule sets, follow these steps:
    1. Click the Related Rule Sets tab.
    2. Click Include rule set NW_plus_circle_o.png.
      The Include Rule Set dialog box is displayed.
    3. Select a Related rule set to include.
    4. In the Comment field, enter an explanation of the relationship.
    5. Click OK.
    6. To include additional rule sets, repeat steps b through e.

  6. On the Options tab, enter the following values:

    Field

    Description

    Log mode

    Select one of the following values to determine the severity of violations of schema rules in this rule set:

    Value

    Description

    Log a warning for violations

    The validation process logs violations as warnings, and the operation can end successfully. This log mode overrides the log mode of any schema rule defined for this rule set.

    Log a failure for violations

    (Default) The validation process logs violations as errors, and the operation fails. This log mode is overridden if a parent rule set's log mode is set to warn.

    Setting the rule set log mode to warn overrides all log modes in the defined rules and included rule sets.

    Comment

    Enter a description of the purpose of the rule set.

  7. Click Save changes  NW_floppy.png to save the rule set definition.
  8. Click Back back_icon_app-24.png.

To edit a schema rule set

  1. In the Product Tools perspective, select a Schema Standards Manage Schema Rules view.
  2. In the Manage Schema Rules grid, select a rule set that you want to edit and click Edit rule set NW_pencil_adapt.png.
    The Edit rule set view is displayed.

  3. On the Rules tab, you can perform the following actions:

    Purpose

    Action

    Add a rule

    1. Click Add rule NW_plus_circle_o.png.
    2. Enter the rule definition. For more information, see Defining-a-schema-rule.
    3. Click OK.

    Edit a rule

    1. Select a rule and click Edit rule NW_pencil_adapt.png.
    2. Modify the rule definition and options. For more information, see Defining-a-schema-rule.
    3. Click OK.

    Delete rules

    1. Select one or more rules for deletion and click Delete rules NW_minus_circle_o.png.
      If any of the selected rules have a NW_plus_circle_green.png next to them, the Delete Rules dialog box is displayed. Otherwise, a NW_minus_circle_red.png is displayed next to each rule. 
    2. In the Delete Rules dialog box, click Yes.
      Selected rules with a NW_plus_circle_green.png next to them are removed from the grid. For all other selected rules, a NW_minus_circle_red.png is displayed next to them.

    Copy a rule

    1. Select a rule to copy and click Copy rule NW_files_copy_o.png .
    2. Modify the rule definition and options. For more information, see Defining-a-schema-rule.
    3. Click OK.

    Rename a rule

    Rename rule is disabled if any updates are pending.

    1. Select a rule and click Rename rule.
    2. In the Rename Schema Rule dialog box, enter the New name for the rule.
    3. Click OK.

    Reset rule changes since last save

    Reset rules NW_refresh.png is disabled for any new rules (NW_plus_circle_green.png).

    1. Select one or more rules and click Reset rules NW_refresh.png.
    2. In the Reset Rules dialog box, click Yes.

    Activate a rule

    In the second column of a rule, click NW-circle_thin_o.png.

    If the rule was previously saved, NW_pencil_adapt_teal.png is displayed in the first column next to the rule.

    Deactivate a rule

    In the second column of a rule, click NW-check_circle_orange.png.

    If the rule was previously saved, NW_pencil_adapt_teal.pngis displayed in the first column next to the rule.

  4. On the Related Rule Sets tab, you can perform the following actions:

    Purpose

    Action

    Include a rule set

    1. Click Include rule set NW_plus_circle_o.png.
      The Include Rule Set dialog box is displayed.
    2. Select a Related Rule set to include.
    3. Enter a description to explain the relationship.
    4. Click OK.

    Edit the include rule set comment

    1. Select a rule set.
    2. Click Edit comment NW_pencil_adapt.png.
    3. In the Edit Related Rule Set dialog box, enter a description to explain the relationship.
    4. Click OK.

    Remove rule sets

    1. Select one or more rule sets.
    2. Click Remove rule sets NW_minus_circle_o.png.
    3. In the Remove Related Rule Sets dialog box, click Yes.

    Activate a rule set

    In the first column, click NW-circle_thin_o.png.

    Deactivate a rule set

    In the first column, click NW-check_circle_orange.png.

  5. On the Options tab, update the following values:

    Field

    Description

    Log mode

    Select one of the following values to determine the severity of violations of schema rules in this rule set:

    Value

    Description

    Log a warning for violations

    The validation process logs violations as warnings, and the operation can end successfully. This log mode overrides the log mode of any schema rules defined for this rule set.

    Log a failure for violations

    (Default) The validation process logs violations as errors, and the operation fails. This log mode is overridden if a parent rule set's log mode is set to warn.

    Setting the rule set log mode to warn overrides all log modes in the defined rules and included rule sets.

    Comment

    Enter a description of the purpose of the rule set.

  6. Click Save changes  NW_floppy.png.
  7. Click Back back_icon_app-24.png.

To delete schema rule sets

  1. In the Product Tools perspective, select a Schema Standards Manage Schema Rules view.
  2. In the Manage Schema Rules grid, select one or more rule sets for deletion.
  3. Click Delete rule sets NW_minus_circle_o.png.
    The Delete Rule Sets dialog box displays a list of the rule sets that you selected.
  4. In the Delete Rule Sets dialog box, verify the rule sets that you selected and perform one of the following actions:
    • To confirm the deletions, click Yes.
    • To cancel the deletions, click No.

To copy a schema rule set

  1. In the Product Tools perspective, select a Schema Standards Manage Schema Rules view.
  2. In the Manage Schema Rules grid, select a rule to copy.
  3. Click Copy rule set  NW_files_copy_o.png.
    The Copy rule set view is displayed.
  4. Edit the copied rule set name so that the name is unique.

  5. On the Rules tab, you can perform the following actions:

    Purpose

    Action

    Add a rule

    1. Click Add rule NW_plus_circle_o.png.
    2. Enter the rule definition. For more information, see Defining-a-schema-rule.
    3. Click OK.

    Edit a rule

    1. Select a rule and click Edit rule NW_pencil_adapt.png.
    2. Modify the rule definition and options. For more information, see Defining-a-schema-rule.
    3. Click OK.

    Delete rules

    1. Select one or more rules for deletion and click Delete rules NW_minus_circle_o.png.
      If any of the selected rules have a NW_plus_circle_green.png next to them, the Delete Rules dialog box is displayed. Otherwise, a NW_minus_circle_red.png is displayed next to each rule. 
    2. In the Delete Rules dialog box, click Yes.
      Selected rules with a NW_plus_circle_green.png next to them are removed from the grid. For all other selected rules, a NW_minus_circle_red.png is displayed next to them.

    Copy a rule

    1. Select a rule to copy and click Copy rule NW_files_copy_o.png .
    2. Modify the rule definition and options. For more information, see Defining-a-schema-rule.
    3. Click OK.

    Rename a rule

    Rename rule is disabled if any updates are pending.

    1. Select a rule and click Rename rule.
    2. In the Rename Schema Rule dialog box, enter the New name for the rule.
    3. Click OK.

    Reset rule changes since last save

    Reset rules NW_refresh.png is disabled for any new rules (NW_plus_circle_green.png).

    1. Select one or more rules and click Reset rules NW_refresh.png.
    2. In the Reset Rules dialog box, click Yes.

    Activate a rule

    In the second column of a rule, click NW-circle_thin_o.png.

    If the rule was previously saved, NW_pencil_adapt_teal.png is displayed in the first column next to the rule.

    Deactivate a rule

    In the second column of a rule, click NW-check_circle_orange.png.

    If the rule was previously saved, NW_pencil_adapt_teal.pngis displayed in the first column next to the rule.

  6. On the Related Rule Sets tab, you can perform the following actions:

    Purpose

    Action

    Include a rule set

    1. Click Include rule set NW_plus_circle_o.png.
      The Include Rule Set dialog box is displayed.
    2. Select a Related Rule set to include.
    3. Enter a description to explain the relationship.
    4. Click OK.

    Edit the include rule set comment

    1. Select a rule set.
    2. Click Edit comment NW_pencil_adapt.png.
    3. In the Edit Related Rule Set dialog box, enter a description to explain the relationship.
    4. Click OK.

    Remove rule sets

    1. Select one or more rule sets.
    2. Click Remove rule sets NW_minus_circle_o.png.
    3. In the Remove Related Rule Sets dialog box, click Yes.

    Activate a rule set

    In the first column, click NW-circle_thin_o.png.

    Deactivate a rule set

    In the first column, click NW-check_circle_orange.png.

  7. On the Options tab, update the following values:

    Field

    Description

    Log mode

    Select one of the following values to determine the severity of violations of schema rules in this rule set:

    Value

    Description

    Log a warning for violations

    The validation process logs violations as warnings, and the operation can end successfully. This log mode overrides the log mode of any schema rules defined for this rule set.

    Log a failure for violations

    (Default) The validation process logs violations as errors, and the operation fails. This log mode is overridden if a parent rule set's log mode is set to warn.

    Setting the rule set log mode to warn overrides all log modes in the defined rules and included rule sets.

    Comment

    Enter a description of the purpose of the rule set.

  8. Click Save changes  NW_floppy.png to save the rule set definition.
  9. Click Back back_icon_app-24.png  . 

To rename a schema rule set

  1. In the Product Tools perspective, select a Schema Standards Manage Schema Rules view.
  2. In the Manage Schema Rules grid, select a rule set and click Rename rule set.
  3. Enter the New name for the rule set.
  4. Click OK .

Related topics

Deploying-schema-rule-sets

Managing-schema-standards-for-SQL-DDL-statements

Viewing-schema-rule-violations

Assuring-SQL-DML-statement-quality

 

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