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 Command Center 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. The BMC AMI Command Center for Db2® application provides a web-based interface to access and manage Db2 databases, data, and custom BMC Db2 applications. Along with providing an intuitive graphical user interface to quickly access database information, it offers secure, role-based access levels to data and actions that can be performed on data.

The course helps understand how to evaluate Db2 errors, troubleshoot SQL statements, and determine performance-related issues using SQL errors and SQL analysis applications in BMC AMI Command Center for Db2. In this course, you will learn how to select SQL statements for analysis, explain a SQL statement, create What-If scenarios, and compare statements to improve SQL statements’ performance. Additionally, you will learn how to evaluate the quality of SQL DML and DDL statements and manage violations and violations to ignore rules.

Note: BMC AMI Command Center for Db2® was formerly known as BMC Workbench for DB2®.

Major release:

BMC AMI Data 13.x

Good for:


Course Delivery:

Web Based Training (WBT) | 1 hours

Course Modules

  • Lesson 1: Troubleshooting SQL Statements
    • Overview of SQL Errors Application
    • Identifying Errors Generated by SQL Statements
    • Overview of SQL Analysis Application
    • Identifying Performance Issues in SQL Statements
    • Selecting the Time Interval for SQL Apps
    • Describing Db2 packages
  • Lesson 2: Tuning SQL Statements
    • Tuning SQL workflow
    • Performance Perspective Commands
    • Setting SQL Tuning Options
    • Selecting a Statement for Analysis
    • Explaining SQL statements
    • Analyzing a statement from Db2 Cache View
    • Analyzing a Statement from Db2 Package View
    • Analyzing an ad-hoc statement
    • Different forms of Explain command
    • Creating a What-If Scenario
    • Creating a What-If Index Scenario
    • Editing a What-If Index Scenario
    • Comparing Statements
  • Lesson 3: Assuring Quality DML Statements
    • Evaluating SQL statement Quality
    • Viewing Expert Rules Violations Summary
    • Viewing and Filtering Detailed Expert Rules Violations
    • Adding a VTI Rule for a Specific Violation
    • Managing VTI Rules
  • Lesson 4: Managing Schema Standards for SQL DDL statements
    • Schema Validation Process
    • Defining Schema Rules
    • Managing Schema Rules
    • Adding a Manage Schema Rules View
    • Adding a Schema Rule Set
    • Adding Related Rules Set
    • Editing a Schema Rule Set
    • Deleting a Schema Rule Set
    • Copying a Schema Rule Set
    • Viewing and Copying Sample Rules
    • Viewing Schema Rule Violations
    • Managing Schema Standards VTI Rules