Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Managing Violations to Ignore rules

(SPE2010)

You can set exceptions to the SQL Assurance expert rules by using Violations to Ignore (VTI) rules. For example, an exception might specify that the rule be skipped for a specific package. Use the following procedures to perform the following tasks on the Violations to Ignore rules:

To add a Manage Violations to Ignore rules view

  1. In the Product Tools perspective, select or add a SQL Assurance view.
  2. In the SQL Assurance detail view, click Manage Violations to Ignore Rules.
    The Manage Violations to Ignore Rules view is displayed.
  3. (Optional)  To filter the VTI rules displayed, click View settings.
    For more information, see Filtering the Violations to Ignore rules.
  4. Click Save Workspace  to save the changes to the workspace.

To add a Violations to Ignore rule

  1. In the Product Tools perspective, select or add a Manage Violations to Ignore Rules view.
  2. Click Add rule  
  3. In the Add Violations to Ignore Rule dialog box, complete the following fields:

    Field

    Description

    Rule name

    Enter a pattern for the Rule message number.

    Collection

    Enter a pattern for the Db2 Collection ID for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.

    Package

    Enter a pattern for the Db2 package name for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.

    VersionEnter a pattern for the Db2 package version for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.

    Comment

    Enter a comment describing the rule.

  4. Click OK.
     is displayed next to each added rule.

  5. Click Save changes   to save all the changes to the Manage Ignore Rules view.

To edit a Violations to Ignore rule

  1. In the Product Tools perspective, select a Manage Violations to Ignore Rules view.
  2. In the Violations to Ignore Rules grid, select a rule that you want to edit and click Edit rule .
    The Edit Violation Ignore Rule dialog box is displayed 
  3. In the Edit Violations to Ignore Rule dialog box, edit the values.
  4. (Optional) Edit additional Violations to Ignore Rules using the Previous rule and Next rule arrows to navigate to another rule.
  5. When you have completed your edits, click OK
      is displayed next to each edited rule.

  6. Verify the edited rules, you can reset the changes, by clicking Reset rules .

  7. Click Save changes   to save all the changes to the Manage Ignore Rules view.

To delete Violations to Ignore rules

  1. In the Product Tools perspective, select a Manage Violations to Ignore Rules view.
  2. In the Violations to Ignore Rules grid, select one or more rules for deletion.
  3. Click Delete rule .
     is displayed next to each rule that you selected to delete.
  4. Verify the rules that you selected to delete. You can undo the deletions by selecting one or more rules marked for deletion and clicking Reset rules  .
  5. Click Save changes   to save the changes to the Manage Violations to Ignore Rules view.

To copy a Violations to Ignore rule

  1. In the Product Tools perspective, select a Manage Violations to Ignore  Rules view.
  2. In the Violations to Ignore Rules grid, select a rule to copy.
  3. Click  Copy rule  .
  4. In the Copy Violations to Ignore Rule dialog box, edit the contents of the following fields as needed:

    Field

    Description

    Rule name

    Enter a pattern for the Rule message number.

    Type

    Select the type of SQL statement to which the rule applies from the following values:

    • All types
    • Static SQL
    • Dynamic SQL

    Collection

    Enter a pattern for the Db2 Collection ID for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.

    Package

    Enter a pattern for the Db2 package name for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.

    VersionEnter a pattern for the Db2 package version for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.
    SQL

    The SQL options are shown only for rules defined to use the SQL statement as criteria. Select the appropriate option button from the following options:

    • Use the SQL statement as criteria
    • Allow any statement

    To view the full statement, click View SQL .

    Comment

    Enter a comment describing the rule.

  5. Click OK.
     is displayed next to each added rule.

  6. Click Save changes   to save all the changes to the Manage Ignore Rules view.

Filtering the Violations to Ignore rules

  1. In the Manage Violations to Ignore rules view, click View settings.
  2. (Optional) Enter a View label to describe the filter.
  3. Click Insert a row .
  4. In the Add Expression dialog box, complete the following fields:

    FieldAction
    ColumnSelect a column name from the displayed list.
    OperatorSelect an operator from the displayed list.
    Note: The LIKE operator accepts only Db2 wildcards (% and _).
    Value

    Enter a value. The value is case sensitive and is automatically enclosed in the delimiter that you selected.
    Note: BMC AMI Command Center requires a nonblank value but does not validate this value.

    LogicSelect one of the following options:
    • AND
    • OR
  5. Click Save.

  6. Repeat steps 2 through 4 to continue adding rows until you have built the search clause for the filter.

  7. (Optional) If you want to make any changes, edit the search criteria.

    Use the following buttons to add, edit, remove, or move rows. (You can perform the same operations by right-clicking in a row and selecting the appropriate command.)

    Button

    Description

    Adds a row to the Search Clause criteria grid

    In the grid, selecting a row and clicking adds a row above the one that you selected.

    Lets you Edit a row in the Search Clause criteria grid

    Removes the selected row from the grid

    Moves the selected row up

    Moves the selected row down

    You can also edit the search clause directly by typing in the search-clause text area.

    Note

    Changes that you type into the text area are not synchronized with the search criteria in the grid. The grid is disabled.

    You can use the following buttons:

    Button

    Description

    Column

    Click in the clause and, from the menu, select a column name to add to the search clause.

    Operator

    Click and, from the menu, select an operator to add to the search clause.

    Click to discard any changes that you made in the text area and to re-synchronize the search clause with the search criteria in the grid. (Clicking this button again would restore your unsaved changes and disable the grid.)

    Note

    This button is available only after you begin making changes in the text area. Making any change in the search criteria grid disables this button.

  8. When finished building the search clause, click OK.

To show properties for a Violations to Ignore rule

  1. In the Product Tools perspective, select a Manage Violation to Ignore Rules view.
  2. In the Violations to Ignore Rules grid, select a rule.
  3. Click Show properties  .
  4. To view the SQL statement, click SQL.
  5. Click  Close .


Was this page helpful? Yes No Submitting... Thank you

Comments