BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Traces and Exception Handling (WBT)

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

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

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

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

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

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

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

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

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

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

Workflow Orchestration

Mainframe Simplification

Popular destinations

BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Traces and Exception Handling (WBT)

Major release:

Good for:

Course Delivery:

Course Modules

Module 1: Application Traces in Db2

Module 2: Thread Workload History and Event Traces

Module 3: Exception Management

Module 4: Workload Definitions and Alarm Management

Module 5: Data Collector and Standalone Functions

Course Modules

Module 1: Application Traces in Db2

Module 2: Thread Workload History and Event Traces

Module 3: Exception Management

Module 4: Workload Definitions and Alarm Management

Module 5: Data Collector and Standalone Functions

Let us know how we can help

Sales & Pricing

Help & Support

Popular destinations

BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Traces and Exception Handling (WBT)

Major release:

Good for:

Course Delivery:

Course Modules

Module 1: Application Traces in Db2

Module 2: Thread Workload History and Event Traces

Module 3: Exception Management

Module 4: Workload Definitions and Alarm Management

Module 5: Data Collector and Standalone Functions

Course Modules

Module 1: Application Traces in Db2

Module 2: Thread Workload History and Event Traces

Module 3: Exception Management

Module 4: Workload Definitions and Alarm Management

Module 5: Data Collector and Standalone Functions

Related Learning Paths

Recommended Trainings