Assuring SQL DML statement quality

(SPE2104)

You can assure the quality of the SQL DML statements used in your applications by reviewing the violations of the expert rules used to evaluate them.

Viewing rule violations

You can use the SQL Assurance view to review:

• A summary of expert rule violations by Db2 subsystem
• A detailed list of expert rule violations for a Db2 subsystem
• Create an instant violation to ignore rule for a specific SQL DML statement
• Access the Manage Violations to Ignore rules view

For more information, see Viewing-expert-rule-violations.

Managing VTI rules

You can use the Manage Violations to Ignore (VTI) rules view to:

• Add new rules
• Edit existing rules
• Remove unwanted rules
• Copy a rule
• Deploy rules to Db2 subsystems where they are needed

For more information, see Managing-SQL-Assurance-VTI-rules and Deploying-SQL-Assurance-VTI-rules.