Key features
Related topics
This page contains the following topics:
Getting started with SQL risk detection
SQL Risk Detection identifies problematic SQL statements that may cause performance degradation, excessive resource usage, or security vulnerabilities. It uses a rule-based engine to flag high-risk statements such as Cartesian joins, missing indexes, and unbounded result sets.
Audience: Db2 DBAs and Application developers
Goal: Learn how to detect and prioritize risky SQL statements before they impact production.
Key Steps:
- Enable SQL risk rules based on business priorities
- Scan SQL statements for violations
- Review and triage flagged statements
- Assign remediation tasks to appropriate teams
Getting started with rule-based SQL evaluation
Rule-Based SQL Evaluation allows teams to define and customize rules that reflect organizational standards and performance goals. These rules can be tailored to different environments and statements.
Audience: Db2 DBAs
Goal: Learn how to configure and apply SQL evaluation rules to enforce best practices.
Key Steps:
- Define rule sets for performance, security, and compliance
- Apply rules to SQL statements
- Adjust severity levels
- Monitor rule violations
Getting started with integration into CI/CD pipelines
SQL Assurance integrates with DevOps workflows to analyze SQL statements before deployment. This ensures that performance and risk issues are addressed early in the development lifecycle.
Audience: Application developers and CI/CD pipeline engineers
Goal: Learn how to embed SQL checks into CI/CD pipelines for proactive analysis.
Key Steps:
- Configure SQL Assurance in your CI/CD tool
- Analyze SQL during build or pre-deployment stages
- Fail builds on critical violations
- Generate reports for development teams
Getting started with audit logging and reporting
Audit Logging and Reporting provide visibility into SQL trends, rule violations, and remediation efforts. These logs support compliance audits and continuous improvement initiatives.
Audience: Db2 DBAs
Goal: Learn how to generate and use audit logs and reports for governance and optimization.
Key Steps:
- Enable detailed logging of SQL evaluations
- Schedule periodic reports
- Share insights with stakeholders
- Track remediation progress