BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Problem and Performance Analysis (WBT)
The BMC AMI Ops for Db2® solution helps Db2® system programmers manage their Db2® environment by monitoring, managing, automating, and optimizing Db2® subsystems for optimal performance and throughput.
The BMC AMI Ops Monitor for Db2® (also referred to as BMC AMI OpsM for Db2®) product is a part of the BMC AMI Ops for Db2® solution. It provides systems programmers and database administrators with an overview of how to access and utilize the Db2 system and application performance monitoring and analysis functions within BMC AMI Ops Monitor for Db2.
Note: BMC AMI Ops Monitor for Db2® was formerly known as MainView for Db2®
Major release:
BMC AMI Ops 13.x
Good for:
Administrators, System Programmers, Operators
Course Delivery:
Web Based Training (WBT) | 5 hours
Course Modules
-
Module 1: Monitoring Overview
- Basics Of Monitoring
- Types Of Monitoring
- Monitoring Key Features
- BMC Monitoring Areas
- Customization of Views and Screens
- Interfaces
- Online Help
- Accessing Historical Data
- Common Commands
- BMC AMI Ops Metrics
-
Module 2: Getting Started with Db2®
- Benefits of Db2 Monitoring
- AMI Ops Monitor For Db2 Overview
- Db2 Application Overview
- Db2 Architecture: Connectivity & Integration
- Key Monitoring Points for Db2
- BMC AMI OpsM For Db2 Navigation
- Web Browser And 3270 Interfaces
- Db2 Concepts
- Db2 SSI Easy Menu
- Db2 DBA Easy Menu
- Db2 Data Sharing Menu
- Easy Menus
- MAIN View
- TOPIC Index
- Accounting Data
- Db2 System Statistics Data
- Db2 System Analysis Groups
- Db2 Statistics Menu
- Db2 System Information
- DDF and DBAT Views
-
Module 3: Realtime Status
- System Overview and Current Exceptions
- Db2 Status List for SSI Context
- Db2 Status or Statistics
- STDB2 and STDB2D View
- Current Threads on STDB2
- Active Threads
- Db2 Health Navigator
- Health Gauge Summary
- Dashboards for Consolidated Exception
- STDASHB, S1HEALTH, and STEXC View
- Db2 Health Navigator Functional Areas
- Db2 Type of Exceptions
- Thread Summary Views
- Thread Detail Views
- THDACTV and THDWARND View
- DUSER View
- Current SQL and Environmental Indicators
- Elapsed Time Analysis
- Threads Easy Menu
- Distributed Threads
- Package Section
- DDF Activity and Connections Views
- Suspended Threads
- Holder and Waiter for Affected Resource
- Lock Contention by Thread
- Current Locks
- Db2 Locking Menu
- Lockout Events
- Lockout Global Blocker/Waiter Summary View
- Lock Wizard Group
-
Module 4: Problem Analysis
- Status Views for Objects
- Restricted Objects
- Page Set From EZDBA
- Db2 Object Menu
- Restricted and Advisory Statuses
- Restricted Access
- Object Status Summary
- Object Status List View
- Object Status Detail View
- Utility Jobs List and Detail Views
- Utility Jobs Status Summary
- Db2 Storage Detail for a Db2 Target
- DB2REALD View
- ZPARM Menu
- ZPARM Installation Parameters
- ZPARM Name Index
- ZPNAMEx View
- OPERTUNE Change Log
- Log Display
-
Module 5: Db2® Performance Analysis
- Local Buffer Pools
- Buffer Pool Statistics
- Buffer pool Activity and Rates
- Page Set Cache
- Page Sets
- Page Set Status
- Page Set Detail
- Total I/O Page Set Summary - Interval
- Volume I/O Summary - Session
- Volume Page Sets
- Data sharing Monitoring
- Db2 Data Sharing Menu
- Global Locking and Detail View
- GBP Group Coupling Facility Status
- GBP Group Coupling Facility Status Summary
- Buffer Pool Page Set GBP-DEP Summary
- Page Set GBP-DEP Status
- GBP Group Coupling Facility Activity Summary
- GBP Group Coupling Facility Activity
- GBP Castout Activity Summary
- Data Sharing Wizard
- Locks and Lockable Resources
- Lockout Analysis
- Db2 Lock Contention
- Lock Contention Analysis Views
- Global Lockout Events
- Lockout Waiter Plan Detail
- Lockout Event Resource Detail
- Lockout Resource Summary
- Lockout Resource Conflict Detail
- Blocker and Connection Type Summary
- Dynamic SQL Cache Menu
- Dynamic SQL Cache Details
- Dynamic SQL Cache Statistics Detail View
- Dynamic SQL Cache Filter Results
- SQL Cache Statement List Detail
- EXPLAIN
- SQL Cache Statement Text
- SQL Cache Statement Statistics