BMC AMI Database Advisor for IMS 3: Core Concepts (WBT)

Overview of IMS Database Management
- Role of IMS databases in mainframe environments
- Data management goals such as availability, performance, and data integrity
- Common challenges in IMS database maintenance
Traditional Database Maintenance Cycle
- Overview of maintenance activities like image copy, reorganization, recovery, and monitoring
- Limitations of manual and traditional maintenance approaches
Introduction to BMC AMI Database Advisor
- Purpose and benefits of using Database Advisor
- How Database Advisor simplifies IMS database management
- Key components and high-level architecture
Getting Started
- Product overview and navigation
- Understanding how Database Advisor fits into daily DBA activities

Database Advisor Functions
- Reorganization thresholds and exception handling
- Automated solutions for performance and space management
Recovery Advisor Functions
- Recovery thresholds and exceptions
- How Recovery Advisor helps ensure data availability
RECON Advisor Functions
- RECON thresholds and exception management
- Importance of RECON data consistency
RECON Utilities
- RECON Reorg utility
- DBRC List History function
Advanced Features
- Conditional Reorg
- Conditional Image Copy
- IC Triggering by CA
- Monitor Recovery feature
- Recovery Wizard for guided recovery operations
Global Configuration
- Description of fields on the AES Global Options Record panel
- How global settings impact Advisor behaviour

DBA Toolkit Overview
- Concept and purpose of the DBA Toolkit
- How it supports IMS database administration tasks
Key Tools
- Generate JCL function
- DEDB Space Calculator
- DBD Map
- Build IDCAMS control statements
- JES Viewer
- Disassemble function
- Object Annotation function
- Auto Configure Wizard
- Access Control
Database Advisor Tools
- Historical Analysis Wizard
- Partition and Randomizer Tuning
- HALDB Modelling and Migration
- How HALDB Modelling and Migration tools work
Reports
- Types of reports generated by Database Advisor
- Exception Forecast report
- Batch reports
- Steps to generate and interpret reports
Benefits
- Key advantages of using Database Advisor tools for proactive IMS database management

Overview of IMS Database Management
- Role of IMS databases in mainframe environments
- Data management goals such as availability, performance, and data integrity
- Common challenges in IMS database maintenance
Traditional Database Maintenance Cycle
- Overview of maintenance activities like image copy, reorganization, recovery, and monitoring
- Limitations of manual and traditional maintenance approaches
Introduction to BMC AMI Database Advisor
- Purpose and benefits of using Database Advisor
- How Database Advisor simplifies IMS database management
- Key components and high-level architecture
Getting Started
- Product overview and navigation
- Understanding how Database Advisor fits into daily DBA activities

Database Advisor Functions
- Reorganization thresholds and exception handling
- Automated solutions for performance and space management
Recovery Advisor Functions
- Recovery thresholds and exceptions
- How Recovery Advisor helps ensure data availability
RECON Advisor Functions
- RECON thresholds and exception management
- Importance of RECON data consistency
RECON Utilities
- RECON Reorg utility
- DBRC List History function
Advanced Features
- Conditional Reorg
- Conditional Image Copy
- IC Triggering by CA
- Monitor Recovery feature
- Recovery Wizard for guided recovery operations
Global Configuration
- Description of fields on the AES Global Options Record panel
- How global settings impact Advisor behaviour

DBA Toolkit Overview
- Concept and purpose of the DBA Toolkit
- How it supports IMS database administration tasks
Key Tools
- Generate JCL function
- DEDB Space Calculator
- DBD Map
- Build IDCAMS control statements
- JES Viewer
- Disassemble function
- Object Annotation function
- Auto Configure Wizard
- Access Control
Database Advisor Tools
- Historical Analysis Wizard
- Partition and Randomizer Tuning
- HALDB Modelling and Migration
- How HALDB Modelling and Migration tools work
Reports
- Types of reports generated by Database Advisor
- Exception Forecast report
- Batch reports
- Steps to generate and interpret reports
Benefits
- Key advantages of using Database Advisor tools for proactive IMS database management

Workflow Orchestration