Getting started
The BMC AMI SQL Assurance for Db2 product is a Java plug-in that runs in the Jenkins automation server. It provides an interface between Jenkins and the SQL Assurance components, which runs on the mainframe. The plug-in lets you evaluate SQL statements for violations and issues related to the performance of SQL statements when accessing Db2 objects.
This section outlines the capabilities of SQL Assurance and describes the advantages of using it.
This section contains the following topics:
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 and the server host name or IP address. This authentication enables you to connect securely to target mainframe servers in one or more environments. |
File transfer | The product transfers files between the Jenkins 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 a JCL to execute 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 a 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 for executing schema changes. You can submit JCL from a data set on the mainframe or a file on the Jenkins server. |
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 intuitive graphical 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 or pipeline that contains SQL violations before progressing them across the z/OS environment.
- The integration with Jenkins enables you 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 or pipeline execution 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.