BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Problem and Performance Analysis (WBT)

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

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

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

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

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

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

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

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

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

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

Workflow Orchestration

Mainframe Simplification

Popular destinations

BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Problem and Performance Analysis (WBT)

Major release:

Good for:

Course Delivery:

Course Modules

Module 1: Monitoring Overview

Module 2: Getting Started with Db2®

Module 3: Realtime Status

Module 4: Problem Analysis

Module 5: Db2® Performance Analysis

Course Modules

Module 1: Monitoring Overview

Module 2: Getting Started with Db2®

Module 3: Realtime Status

Module 4: Problem Analysis

Module 5: Db2® Performance Analysis

Let us know how we can help

Sales & Pricing

Help & Support

Popular destinations

BMC AMI Ops Monitor for Db2® 13.x: Fundamentals for Problem and Performance Analysis (WBT)

Major release:

Good for:

Course Delivery:

Course Modules

Module 1: Monitoring Overview

Module 2: Getting Started with Db2®

Module 3: Realtime Status

Module 4: Problem Analysis

Module 5: Db2® Performance Analysis

Course Modules

Module 1: Monitoring Overview

Module 2: Getting Started with Db2®

Module 3: Realtime Status

Module 4: Problem Analysis

Module 5: Db2® Performance Analysis

Related Learning Paths