Viewing schema rule violations
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
- Open or create a workspace.
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.
- Enter a name for the view.
Select a Time frame for the schema rule violations to display.
- (Optional) To limit the list of Db2 connections to your favorites, select Show only favorites.
Select one or more DB2 connections.
Click OK.
The Schema Standards Violations summary view is displayed in the results pane.
For more information, see Schema Standards Violations summary view.- (Optional) To adjust the records displayed, click View settings.
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.
For more information, see Schema Standards Violations detail view.- (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.
- Click Save Workspace to save the changes to the workspace.
To filter the schema rule violations
To show properties for a schema rule violation
- In the Product Tools perspective, select a Schema Standards Violations view.
- Open a Schema Standards Violations detail view for a Db2 subsystem.
- In the schema rule violations grid, select a violation.
- Click Show properties .
Alternatively, you can double-click a violation to view its properties. - Click Close.
To view the schema rule for a violation
- In the Product Tools perspective, select a Schema Standards Violations view.
- Open a Schema Standards Violations detail view for a Db2 subsystem.
- In the schema rule violations grid, select a violation.
- Click View schema rule.
- Select the Schema Standards Violations view from step 1.
To add a VTI rule for a specific violation
- Select a violation from the grid.
- Click Ignore violation.
The Ignore Violation dialog opens with default values based on data from the violation. (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.- Enter a Comment to explain why the violation is ignored.
- Click OK.
Schema Standards Violations summary view
The following table describes the options available in the Schema Standards Violations summary view:
Task | Description |
---|---|
Change the time interval |
|
Change the subsystems displayed |
|
Refresh the data displayed | Click Refresh . |
View schema rule violations for a subsystem | Perform one of the following actions:
|
Copy data for one or more subsystems to the clipboard |
|
Export data for one or more subsystems to a CSV file |
|
Schema Standards Violations detail view
The following table describes the options available in the Schema Standards Violations detail view:
Task | Description |
---|---|
Change the time interval |
|
Refresh the data displayed | Click Refresh . |
Filter the violations displayed | Perform one or more of the following actions:
|
Clear the filter | Click Clear filter. |
View a sample rule message | Hover the cursor over a section of the pie chart. |
Show properties for a schema rule violation | Perform one of the following actions:
For more information, see To show properties for a schema rule violation. |
Access Manage Violations to Ignore rules view | Click Manage Violations to Ignore rules. For more information, see Managing Schema Standards VTI rules. |
View schema rule associated with a violation | Perform one of the following actions:
|
Add a VTI rule for a specific violation | Perform one of the following actions:
For more information, see To add a VTI rule for a specific violation. |
Delete violations |
|
Return to previous view | Click Back |
Comments
Log in or register to comment.