BMC AMI Database Performance for Db2® 13.x: Fundamentals Concepts (WBT)
BMC AMI Database Performance for Db2® is a collection of technologically advanced solutions that deliver greatly improved performance, reduced application cost, and increased availability. It provides intelligent automation, allowing you to focus your efforts where they matter most: on the performance and availability of critical data assets.
In this course, you identify the key factors influencing database performance. In addition, you have a better understanding of BMC AMI Utility Manager, the use of BMC AMI Reorg for Db2, and the importance of BMC AMI Stats for Db2. Also, you understand how all these products contribute to improving application performance, reducing application costs, and increasing data availability.
Major release:
BMC AMI Data 13.x
Recommended Prerequisites:
Good for:
Administrators, Developers
Course Delivery:
Web Based Training (WBT) | 2 hours
Course Modules
-
Overview of BMC AMI Database Performance for Db2®
- Understand the concept of database performance
- Define database performance management
- Identify the key factors influencing database performance
- Introduction to basic concepts like z/OS, Mainframe, Db2, and data
- Review challenges in front of companies
- Identify features of BMC AMI Data
- Identify key points of world-class data management
- Identify features of BMC AMI Database Performance for Db2 solution
- Understand a high-level overview of each product
- Explain how each product contributes to evaluating database performance for Db2
-
Overview of BMC AMI Utility Manager for Db2®
- Get an overview of Real-Time Statistics (RTS)
- Explain how to start using BMC AMI Utility Manager for Db2
- Discuss the benefits of BMC AMI Utility Manager for Db2
- Discuss an example to invoke the Utility Manager
- Understand the Utility Manager’s processing
- Explain how to use Exceptions, Criteria, Schedule, and Duration tables
- Explain the concept of journal messages
- Discuss summary reports
-
Overview of BMC AMI Reorg for Db2®
- Identify reasons for reorganizing table spaces
- Specify the advantages of reorganizing indexes
- Explain key features
- Explain unique NO SORT Reorg
- Discuss parallelism and throughput in BMC AMI Reorg
- Explain Reorg concurrency comparison
- Identify unique drain management and change apply characteristics
- Understand how to reorganize table spaces
- Understand how to automate your reorganizations
- Understand how to reorganize indexes
- Understand how to restart jobs
- Understand how to rebalance partitions
- Understand how to produce image copies
- Understand how to discard rows from the table
-
Overview of BMC AMI Stats for Db2®
- Explain the basic concepts of BMC AMI Stats for Db2®
- Discuss requirements and restrictions of BMC AMI Stats for Db2®
- List table columns updated by BMC AMI Stats for Db2®
- Understand how to collect statistics for table space and multiple table spaces
- Understand how to collect frequency statistics for all indexed columns
- Understand how to collect distribution statistics for a table space
- Understand how to control what BMC AMI Stats writes to the catalog
- Understand how to control what BMC AMI Stats writes to the Db2 catalog history tables
- Identify the steps to write reports using BMC AMI Stats
- Identify the steps to run BMC AMI Stats with BMC AMI Utility Manager