Product overview
Related topics
BMC AMI SQL Assurance for Db2 helps organizations proactively identify and remediate risky or inefficient SQL statements in their Db2 environments. You can continuously analyze SQL statements using customizable rules and performance metrics. SQL Assurance enables teams to maintain stable, high-performing Db2 systems while supporting compliance and DevOps integration. It empowers Application developers and Db2 DBAs to catch issues early, optimize queries, and ensure that SQL behavior aligns with business and technical standards.
You can use BMC AMI SQL Assurance for Db2 to accomplish the following tasks:
- Identify and resolve problematic SQL before it reaches production
- Improve application performance by optimizing inefficient queries
- Integrate SQL quality checks into CI/CD pipelines for early detection
- Enhance collaboration between Application developers and Db2 DBAs with shared insights and tools
Product capabilities
SQL Assurance provides the following capabilities across the IBM z/OS Management Facility (z/OSMF) framework:
Capability | Description |
|---|---|
Authentication | The product prompts you for information, such as your IBM Resource Access Control Facility (RACF) credentials, certificate credentials for Universal Connector and the server host name or IP address. Using this authentication, you can connect securely to target mainframe servers in one or more environments. |
File transfer | The product transfers files between the automation server and the mainframe. |
Analyze Static SQL | Based on your object and SQL rules input, the product performs an Explain on the SQL statements for a subsystem. It builds JCL to run the Explain and compares the SQL statements to the SQL rules. |
Analyze Dynamic SQL | Based on your Dynamic Statement Cache and SQL rules input, the product builds JCL to extract SQL statements, for a subsystem, from the Dynamic Statement Cache in the DSN_STATEMENT_CACHE_TABLE. The product subsequently performs an Explain and compares the SQL statements to the SQL rules. |
JCL execution | You can submit a JCL stream to the mainframe via a data set member on the mainframe, file on the deployment server or ad hoc JCL input directly in the step. |
Reporting | The BMC AMI Command Center for Db2 administers the reporting and managing of SQL violations. |
Benefits
BMC AMI SQL Assurance for Db2 has the following benefits:
- Application development teams can deploy changes at the required speed without abandoning the safeguards that the DBA teams require to ensure the reliability and capability of Db2 applications.
- You can automate the deployment of application code containing SQL statements while ensuring application performance.
- You can use the YAML file and Jenkins user interface to configure and manage SQL statement violations generated during the analysis of application SQL.
- You can save a significant amount of time when reviewing, approving, or maintaining mainframe business applications based on Db2 by using SQL Assurance.
- You can review the results of your project, pipeline, or workflow that contains SQL violations before progressing them across the z/OS environment.
- You can use CI/CD integration to implement your preferred degree of oversight when evaluating SQL statements for SQL rule violations across the z/OS environment via a batch job.
- DBA teams can review the violation details received from the project, pipeline, or workflow running via the BMC AMI Command Center for Db2 product, a web-based graphical user interface.
- DBA teams can ignore violations, when required, via the BMC AMI Command Center for Db2.
User roles
| Role | Responsibilities |
|---|---|
| Application developer | Write and submit SQL as part of application development; review flagged queries |
| Db2 DBA | Monitor SQL performance, tune queries, and manage rule configurations |
| DevOps engineer (CI/CD pipeline engineer) | Integrate SQL Assurance into CI/CD workflows and automate evaluations |
| System programmer | Configure access, monitor usage, and ensure system availability |
| z/OS security administrator | Authorize user IDs, grant access to z/OSMF resources, manage profiles and configure SSL certificates to ensure compliance with security standards |
| Linux administrator | Install AMI DevOps plug-ins and applications |
For more information, see Roles and Permissions.
Key Integrations
You can integrate BMC AMI SQL Assurance for Db2 with the following BMC products:
- BMC AMI SQL Explorer for Db2 – For resolution of common SQL-related performance issues
- BMC AMI Command Center for Db2 — To manage SQL Assurance violations and ignored violations
- You can also integrate the product with third-party CI/CD tools, such as Jenkins, Azure DevOps, GitHub Actions, and GitLab CI/CD, for pipeline automation.
Interfaces and Components
BMC AMI SQL Assurance for Db2 combines intuitive interfaces with powerful backend components to evaluate SQL statements across environments.
The following table summarizes the key tools and systems that support deployment, validation, and governance.
| Tool or system | Type | Description |
|---|---|---|
| CI/CD web Console | Interface | Manages SQL validation, configuring environments and monitoring deployments via Jenkins, Azure DevOps, GitHub Actions or GitLab CI/CD for automated deployments |
| Command-line interface (CLI) | Interface | Supports scripting and automation; used in CI/CD pipelines for SQL evaluation |
| REST APIs | Interface | Enables integration with third-party systems, and provides endpoints for managing deployments |
| Mainframe integration layer | Component | Runs SQL evaluation via z/OSMF |
| SQL evaluation engine | Component | Runs rule-based analysis and performance checks on SQL statements . |
| Audit and Compliance Module | Component | Logs SQL violations and supports ITIL, SOX, and governance standards. |