icon_CloudMgmt icon_DollarSign icon_Globe icon_ITAuto icon_ITOps icon_ITSMgmt icon_Mainframe icon_MyIT icon_Ribbon icon_Star icon_User icon_Users icon_VideoPlay icon_Workload icon_caution icon_close s-chevronLeft s-chevronRight s-chevronThinRight s-chevronThinRight s-chevronThinLeft s-chevronThinLeft s-trophy s-chevronDown

BMC AMI SQL Performance for Db2® 13.x: Fundamentals Concepts (WBT)

BMC AMI SQL Performance for Db2® delivers modern solutions designed for a new generation of mainframe professionals to quickly eliminate wasteful SQL statements, manage performance throughout the application lifecycle, and audit privileged access to reduce risk.

You will start this course by learning some basics of SQL performance evaluation and query optimization. You will get a better understanding of BMC AMI Apptune for Db2, the setting up of SQL Explorer, SQL Assurance capabilities, and so on. In addition, you will be able to understand how all these products contribute to rapidly diagnosing performance problems, tuning SQL, and anticipating and resolving slowdown to avoid bad SQL.

Major release:

BMC AMI Data 13.x

Good for:


Course Delivery:

Web Based Training (WBT) | 2 hours

Course Modules

  • Introduction to BMC AMI SQL Performance for Db2®
    • Revise the basics of SQL and Db2
    • State the need for SQL performance evaluation
    • Identify the concept of performance tuning
    • Explain the concept of query optimization
    • Understand the use of query optimization in SQL performance
    • Explain the features of BMC AMI SQL Performance for Db2
    • Describe the high-level overview of each product in the BMC AMI SQL Performance for the Db2 solution
    • Understand how each product contributes to evaluating SQL performance for Db2
  • BMC AMI Apptune for Db2®
    • Explain an overview of BMC AMI Apptune for Db2
    • Identify BMC AMI Apptune for Db2 features
    • Discuss Apptune components
    • List types of Apptune reports
    • Explain the command interface panel
    • List user options
    • Describe the EXPLAIN function
    • Understand the use of Apptune
    • List Apptune reports
    • Define workload analysis task
    • Describe the concept of batch processing in Apptune
    • Understand the user profile feature of Apptune
    • Identify monitoring modes of Apptune
    • Learn basics of Apptune filters
  • BMC AMI SQL Explorer for Db2®
    • Analyze the SQL Explorer for Db2
    • Identify common problems while working with SQL
    • Discuss SQL Explorer interface
    • Discuss an overview of key features of SQL Explorer
    • Describe the EXPLAIN SQL statement
    • Describe the COMPARE SQL statement
    • Define Mismatch Analysis
    • Define Impact Analysis
    • Discuss the migration of access path
    • statistics to another subsystem
    • Discuss how to generate automatic DECLARE TABLE statements
  • BMC AMI SQL Assurance for Db2®
    • Define the components of SQL Assurance
    • Explain the capabilities of SQL Assurance
    • List the advantages of SQL Assurance
    • Demonstrate how to prepare a project
    • Explain how to create a project
    • Define how to configure a project
    • Explain how to build a project and review its output
    • Demonstrate using SQL Assurance as a part of a pipeline
    • Define the SQL Assurance rules