BMC AMI SQL Assurance for Db2® 13.x: Fundamentals Using (WBT)
BMC AMI SQL Assurance for Db2® product is a component of the BMC AMI SQL Performance for Db2® solution. With the help of BMC AMI SQL Assurance for Db2, you can validate application SQL run against Db2 for z/OS®. This product can drive the analysis of application SQL statements against customer and BMC-defined SQL programming standards and combines Jenkins with some BMC automated SQL Performance products.
This course will help you understand how to run BMC AMI SQL Assurance for Db2 in the Jenkins automation server as well as in standalone mode via batch jobs. Additionally, you will be able to analyze SQL Assurance reports, ignore violations, and manage violations. With the Jenkins integration, you will be able to build a SQL Assurance project pipeline to evaluate static and/or dynamic SQL statements for SQL rule violations across the z/OS environment via batch jobs. Furthermore, you can review the violation details received from the pipeline execution or batch jobs run in stand-alone mode via the BMC AMI Command Center for Db2 product, which is a web-based graphical user interface.
Major release:
BMC AMI Data 13.x
Good for:
Administrators, Developers
Course Delivery:
Web Based Training (WBT) | 2 hours
Course Modules
-
Module 1: Using BMC AMI SQL Assurance for Db2 on Jenkins
- Getting Started with BMC AMI SQL Assurance for Db2
- Why SQL Assurance Is Important?
- BMC AMI SQL Assurance for Db2: Conceptual Architecture
- Reviewing the Capabilities of BMC AMI SQL Assurance for Db2
- Workflow of Using BMC AMI SQL Assurance for Db2 through Jenkins
- Step 1: Preparing for a Project
- Creating and Configuring a Project
- Step 2: Creating a Project
- Step 3(a): Configuring Parameters in a Project
- Step 3(b): Configuring Build Steps in a Project
- Adding Build Steps for Static and Dynamic SQL Analysis
- Configuring the Sample Project Provided by BMC
- Configuring Values to Analyze Static SQL – Package Object List
- Configuring Values to Analyze Dynamic SQL – Where Clause
- Building a Project and Reviewing Output
- Using BMC AMI SQL Assurance as a Part of a Pipeline
- Step 4: Building a Project
- Step 5: Reviewing Console Output for a Build
- Reviewing Violations from BMC AMI Command Center for Db2
- Demonstration: Building a SQL Assurance Pipeline on Jenkins
- Getting Started with BMC AMI SQL Assurance for Db2
-
Module 2: Using BMC AMI SQL Assurance for Db2 in Stand-alone Mode
- Configuring Static and Dynamic SQL JCL Jobs
- Configuring Parameters for Static and Dynamic SQL JCL Jobs
- Analyzing Existing Static SQL Defined on Your Subsystem
- Analyzing SQL from the Dynamic Statement Cache
- Viewing SQL Assurance Report
- Running SQL Assurance Job in Standalone Mode
- Navigating to SQL Assurance Report in Stand-alone Mode
- Analyzing SQL Assurance Report (AS$RSLT)
- Using SQL Assurance View
- BMC AMI Command Center for Db2: SQL Assurance View Capabilities
- Navigating to SQL Assurance View of BMC AMI Command Center for Db2
- Viewing SQL Assurance Violation Details
- Viewing Properties of Expert Rules Violations
- Filtering Expert Rules Violations
- Adding a VTI Rule for a Specific Violation
- Managing SQL Assurance VTI Rules
- Adding Manage Violations to Ignore Rules View
- Adding a VTI Rule
- Editing a VTI Rule
- Deleting a VTI Rule
- Copying a VTI Rule
- Deploying SQL Assurance VTI Rules
- Demonstration: Running SQL Assurance in Stand-alone mode
- Configuring Static and Dynamic SQL JCL Jobs