BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Traces and Exception Handling (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.
This web-based course introduces learners to the features and capabilities available in BMC AMI Ops Monitor for Db2. The course also provides an understanding of how to use these features and capabilities to analyze system statistics, storage utilizations, current thread activity, performance, and key exceptions.
Major release:
BMC AMI Ops 13.x
Good for:
Administrators, System Programmers, Operators
Course Delivery:
Web Based Training (WBT) | 4 hours
Course Modules
-
Module 1: Application Traces in Db2
- Traces Overview
- Application Trace Facility
- Flexible Trace Facility
- Application Trace Usage
- Types of Application Traces
- Summary Trace
- Default Summary Traces
- Detail Trace
- Collecting Trace Data
- Controlling Active Traces
- Application Trace Panels for Starting a Trace
- Start a Trace
- Summary Trace for All Threads
- Detail Trace Selection Criteria Panel
- Trace Exception Filters
- Detail Trace Events
- Detail Trace Options
- Trace Logging
- Trace Log Data Set Options
- Active Traces
- Trace Display Services
- STRAC View
- DTRAC and UTRAC View
- Input Output Event Views
- LTRAC View
- EXPAND Displays
- STRAC Base Section
- STRAC Summary in Detail Trace with SQL
- STRAC Summary in Detail Trace with SCAN Events
- Detail DTRAC View
- Trace Displays Navigation
- Graphic THRDHIST
- Trace Summary by Time View
- Managing Current Traces
- History Traces Application
- Managing History Traces
- Managing History Traces Commands
- Print a Trace
- Schema of Trace Functions
- Buffers for Detail Traces
- Detail User Status for Active Detail Trace
- UTRAC View
- Incomplete History Trace
- Detail Trace Recommendations for Logging
-
Module 2: Thread Workload History and Event Traces
- Analyzing Recent Workload History
- Thread History Sources
- Analyzing Thread History
- Thread History Traces
- Thread Analysis Query or Drilldown View
- Analyzing by Thread Query
- Thread Analysis Query or Drilldown View Hyperlinks
- Thread Interval Summary
- Additional Details in the HTDTLZ View
- Summary by Hour
- Summary by Interval
- Summary by Connect Type
- Trace Thread List View
- Thread Summaries by Plan Name
- Exception Count on the TRLTRAC View
- TRSTRAC View
- Data Collector Rollup Summary Thread Reports
- Local Report Filters
- Accounting Package Summary
- Thread Accounting Package Summary
- Accounting Summary by Interval
- System Event Views
- Event Traces
- Authorization Failures for Db2 Events
- Db2 Commands Executed
- RID Failures
- Dataset Open/Close
- Dynamic SQL/Mini Plan
- Printing trace log data sets
- Types of Input Sources
- Output Format of Reports
- Report Requests
- Discarded trace records
-
Module 3: Exception Management
- Exception Management Techniques
- Monitor Administration Facility
- Monitor Services
- Monitors
- Automatic Monitor Activation
- Types of Monitors
- Resource Monitors
- Workload Monitors
- Data Types Measured
- Warning Conditions
- Methods to Request Monitor Service
- Actions on the SM View
- Start Monitors View
- Starting a Resource Monitor
- Valid Values for Monitor Attributes
- Starting a Workload Monitor
- Navigate to the Active Monitors View
- Active Monitors View
- Starting a Monitor Manually
- Active Timer Requests
- AT View Line Commands
- Monitor Plot
- DMON View in an SSI Context
- DSERV View
- DWARN View
- Monitor Summary by Area–Interval
- Monitor Cluster View
- Exception Monitoring
- Exception Menu
- Uses of Background Exception Samplers
- Control Exception Messages
- Background Exception Sampler Monitors
- Exception Parameter Severity Level
- List of Information Background Exception Messages
- List of Warning Background Exception Messages
- List of Severe Background Exception Messages
-
Module 4: Workload Definitions and Alarm Management
- Workload Definitions
- Define Db2 Workloads
- DWKLDDEF View
- Add New Db2 Workload
- Parameters for Workload Identification
- Workload Time and Performance Goals
- Parameters for Thread Selection
- Viewing Your Service Objectives
- DWKLDDEF View Line commands
- Alarm Management Overview
- Alarm Management Components
- Alarm Management Features and Benefits
- Alarm Definition Libraries
- Alarm Definitions
- Alarm Reports
- Create a New Alarm Definition
- AMD View
- Useful MVDb2 Alarm Definitions
- Delivered Sample Alarms
-
Module 5: Data Collector and Standalone Functions
- BMC AMI Ops Monitor for Db2 Architecture
- Data Collector Features
- Online Data Collector Reports
- Event Traces and IFCIDS Collected by the DBC
- EDM Pool Database Details
- EDM Pool Cursor Details
- EDM Pool Package Details
- Data Collector Report Architecture
- DC Batch Reporting
- DOMBRPT1 Utility
- Control Statements for Reports
- Data Collector Report Output
- DOMBRPT1 Processing
- DOMBRPT1 Utility SYSIN Examples
- AMI Ops Db2 DC Main Menu
- DC Administration
- DOMPLEX Product Option Sets Panel Characters
- Archive Directory
- Trace Archive Directory Menu
- The Explain Function
- Explain Entry Points in BMC AMI Apptune for Db2
- Explain Interface
- Working with Explain Results
- Performance Reporter Architecture
- Performance Reporter Tables
- Process to load SMF data with job DPRSMF
- Performance Reporter Benefits