Viewing schema rule violations

(BMC.DB2.SPE2110)

The Schema Standards Violations view displays a summary of the SQL DDL statements that violated the schema rules used to ensure SQL DDL schema standards.

To view schema rule violations

1. Open or create a workspace. 

2. In the Product Tools perspective, click the Add View  menu arrow, and then click Add Schema Standards Violations 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 schema 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 Schema Standards Violations summary view is displayed in the results pane.
   For more information, see Schema Standards Violations summary view.

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

9. Open the subsystem detail view by performing one of the following actions:

   • Click the subsystem's bar on the bar chart.
   • Double-click 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 Schema Standards Violations detail view is displayed.
   For more information, see Schema Standards Violations detail view.

10. (Optional) To filter the violations displayed in the subsystem detail view, perform one or more of the following actions:
    • 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 schema rule violations.
11. Click Save Workspace  to save the changes to the workspace.

To filter the schema rule violations

1. In the Schema Standards Violations 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. Information 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. Information BMC AMI Command Center requires a nonblank value, but does not validate this value.
   Logic	Select AND or 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) To make any changes, edit the search criteria.Use the following buttons to add, edit, remove, or move rows: 

   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.

   Information

   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 synchronize the search clause with the search criteria in the grid. (Clicking this button again would restore your unsaved changes and disable the grid.) Important 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 you have finished building the search clause, click OK.

To show properties for a schema rule violation

1. In the Product Tools perspective, select a Schema Standards Violations view.
2. Open a Schema Standards Violations detail view for a Db2 subsystem.
3. In the schema rule violations grid, select a violation.
4. Click  Show properties  .
   Alternatively, you can double-click a violation to view its properties.
5. Click Close.

To view the schema rule for a violation

1. In the Product Tools perspective, select a Schema Standards Violations view.
2. Open a Schema Standards Violations detail view for a Db2 subsystem.
3. In the schema rule violations grid, select a violation.
4. Click View schema rule.
5. Select the Schema Standards Violations view from step 1.

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 set	Enter a pattern for the name of the rule set. You can use the % wildcard.
   Rule name	Enter a pattern for the rule message number. You can use the % wildcard.
   Object Type	Select the object type to which the rule applies from the following values: Any type Database Index Index Partition Storage Group Table Table Column Table Space Table Space Partition Volume
   Name part 1	Enter a pattern for the first part of the Db2 object name for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.
   Name part 2	Enter a pattern for the second part of the Db2 object name for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.
   Name part 3	Enter a pattern for the third part of the Db2 object name for which you want to create a rule. You can use the % wildcard. A blank field is interpreted as containing a single % wildcard.

   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.

Schema Standards Violations summary view

The following table describes the options available in the Schema Standards Violations summary view:

Schema Standards Violations detail view

The following table describes the options available in the Schema Standards Violations detail view: