Viewing expert rule violations

(SPE2104)

The SQL Assurance view displays a summary of the SQL statements that violated the expert rules used to evaluate their performance.

To view expert rule violations

1. Open or create a workspace. 

2. In the Product Tools perspective, click the Add View  menu arrow, and then click Add SQL Assurance View.

   Tip

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

3. Enter a name for the view.

4. Select a Time frame for the expert rule violations to display.

5. (Optional) To limit the list of Db2 connections to your favorites, select Show only favorites.

6. Select one or more Db2 connections.

7. Click OK.

   The SQL Assurance summary view is displayed in the results pane.
   For more information, see SQL Assurance summary view.

8. (Optional) To adjust the records displayed, click View settings .

9. Open the subsystem detail view by:

   • Clicking the subsystem's bar on the bar chart

   • Double-clicking the subsystem's row on the grid

   • Select the subsystem's row on the grid and click Details

   • Right-click the subsystem's row on the grid and select Details from the context menu
   The SQL Assurance detail view is displayed.
   For more information, see SQL Assurance detail view.
10. (Optional) To filter the violations displayed:
    • Adjust the Time frame and click Refresh 
    • Select or clear the check boxes in the pie chart legend
    • Click Filter violations 
      For more information, see To filter the expert rule violations.
11. Click Save Workspace  to save the changes to the workspace.

To filter the expert rule violations

1. In the SQL Assurance details view, click Filter violations  .
2. Click Insert a row .

3. In the Add Expression dialog box, complete the following fields:

   Field	Action
   Column	Select a column name from the displayed list.
   Operator	Select 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.
   Logic	Select one of the following options: AND OR

4. Click Save.

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

6. (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.

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

To show properties for an expert rule violation

1. In the Product Tools perspective, select an SQL Assurance view.
2. Open an SQL Assurance detail view for a Db2 subsystem.
3. In the expert rule violations grid, select a violation.
4. Click Show properties  .
5. (Optional) To view the SQL statement, click SQL.
6. Click  Close .

To add a VTI rule for a specific violation

1. Select a violation from the grid.
2. Click Ignore violation.
   The Ignore Violation dialog opens with default values based on data from the violation.

3. (Optional) Edit 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.
   Version	Enter 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 .

   
   If you adjust the default values the rule might apply to multiple violations.

4. Enter a Comment to explain why the violation is ignored.
5. Click OK.

SQL Assurance summary view

The following table describes the options available in the SQL Assurance summary view:

SQL Assurance detail view

The following table describes the options available in the SQL Assurance detail view: