Getting started
The BMC AMI SQL Assurance for Db2 improves SQL statement performance by enforcing your SQL programming standards. It evaluates your SQL statements against BMC-provided standards and user-defined standards. BMC AMI SQL Assurance reports any violations encountered so that you can correct potential performance problems before the SQL statements reach production.
BMC AMI SQL Assurance is available both as a plug-in for the Jenkins automation server and a containerized application (Universal Connector) for continuous integration and continuous deployment (CI/CD) tools. Universal Connector is certified for the following CI/CD tools:
- Azure DevOps
- GitHub Actions
- (BMC.DB2.SPE2501)GitLab CI/CD
Universal Connector provides an interface between CI/CD tools and the following BMC AMI SQL Performance products:
- BMC AMI SQL Explorer for Db2
- BMC AMI Command Center for Db2
You can use the Jenkins plug-in and container applications to evaluate SQL statements against BMC and customer-defined SQL programing standards for violations and issues related to the performance of SQL statements when accessing Db2 objects.
This section outlines the capabilities and advantages of SQL Assurance.
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 adhoc JCL input directly in the step. |
Reporting | The BMC AMI Command Center for Db2 administers the reporting and managing of SQL violations. |
Product advantages
This product has the following advantages:
- 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.