BMC AMI Command Center for Db2® 13.x: Fundamentals for SQL and Troubleshooting (WBT)
BMC AMI Command Center for Db2® is 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.
This course is designed to introduce you to the different ways to access, view, and work with SQL statements using BMC AMI Command Center for Db2. To effectively manage database schemas, you will find various ways to compare database schemas, generate reports and manage schema standards rules for SQL statements. Moreover, you will gain skills to generate, create SQL commands, invoke stored procedures, define rules for violations and manage violations to ignore rules. With the help of this course, you will be able to quickly troubleshoot SQL statements for errors, and performance issues and tune them in no time.
Major release:
BMC AMI Data 13.x
Recommended Prerequisites:
Good for:
Developers, Administrators
Course Delivery:
Web Based Training (WBT) | 2 hours
Course Modules
-
Working with Db2 Schemas
- Comparing Db2 Schemas
- DB2 Schema Comparison Types
- Schema Compare view from a New Report
- Schema Compare using an Existing Report
- Viewing CDL statements
- Overview by Statement Type
- Overview by Object Type
- Schema Management Options
- Managing Schema Standards for SQL DDL Statements
- Schema Validation Process
- Managing Schema Rules view
- Managing Ruleset
- Managing Schema Rules Violations
- Managing Schema Standards VTI rules
- Comparing Db2 Schemas
-
Working with SQL Commands
- Working with SQL Commands
- Overview of Scratchpad Editor
- Supported Commands
- Generating a Command
- Generating and Running Alter DDL statements
- Creating Commands
- Editing Text Files in Scratchpad
- Running a Command from Scratchpad
- Setting Scratchpad Options
- Invoking a Stored Procedure
- Updating a Stored Procedure
- Assuring SQL Statements Quality
- Evaluate SQL statement Quality
- Viewing Expert Rules Violations Summary
- Viewing Detailed Expert Rules Violations
- Adding a VTI Rule for a Violation
- Managing VTI Rules
- Working with SQL Commands
-
Troubleshooting and Tuning SQL Statements
- 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
- Tuning SQL statements
- Tuning SQL workflow
- Performance Perspective Overview
- 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
- Creating a What-If Scenario
- Comparing Statements
- Simulation: Working with SQL Errors and SQL Analysis Applications
- Troubleshooting SQL statements