Assuring SQL DML statement quality

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.

Related topics

Viewing expert rule violations

Managing SQL Assurance VTI rules

Deploying SQL Assurance VTI rules

Managing schema standards for SQL DDL statements

Tuning SQL

Troubleshooting SQL statements

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.

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*