Key concepts

Learn about the following areas of the BMC AMI SQL Assurance for Db2 product.
The following key concepts apply throughout the system and provide the foundation for how SQL statements are monitored, analyzed, and optimized to ensure performance, efficiency, and reliability across your Db2 environments.

This section introduces the key ideas that support the product’s functionality.

• SQL Risk Detection
  SQL Risk Detection identifies potentially harmful or inefficient SQL statements using a rule-based engine. It flags issues such as missing indexes, unbounded result sets, and inefficient joins. This helps teams proactively address performance and stability risks before they reach production.

• Rule-Based Evaluation
  SQL Assurance uses customizable rule sets to evaluate SQL statements against performance, security, and compliance standards. Rules can be adjusted to reflect organizational priorities and SQL characteristics. This enables consistent enforcement of best practices and reduces manual review effort.

• CI/CD Integration
  SQL Assurance integrates with CI/CD pipelines to analyze SQL statements during development and deployment. This helps catch performance and risk issues early in the lifecycle, promoting shift-left practices and reducing production incidents.

• Audit Logging and Reporting
  All evaluations, rule violations, and user actions are logged. SQL Assurance generates reports that support compliance audits and performance reviews. This enhances visibility, accountability, and governance across teams.