BMC AMI Log Master for Db2® 13.x: Fundamentals Using (WBT)
BMC AMI Log Master for Db2® enables the users to access and use the Db2 log for purposes beyond restart and recovery. With BMC AMI Log Master, you can easily retrieve information stored in Db2 log records to support data migration and audit tasks. Special product features provide innovative solutions to the complex problems associated with logical backout and recovery of application transactions.
This course introduces the fundamentals of using BMC AMI Log Master for Db2, including the application architecture and key features. In addition, you learn about the three major areas of the application: recovery, auditing, and data migration.
Major release:
BMC AMI Data 13.x
Recommended Prerequisites:
Good for:
Administrators, System Programmers
Course Delivery:
Web Based Training (WBT) | 3 hours
Course Modules
-
Module 1: Introduction to BMC AMI Log Master for Db2
- BMC AMI Log Master for Db2 Overview:
- Overview of BMC AMI Log Master for Db2
- Overview of log data flow
- Overview of Bootstrap Data Set (BSDS)
- Log Master architecture
- Key features of BMC AMI Log Master for Db2
- Navigating BMC AMI Log Master for Db2
- BMC AMI Log Master for Db2 Overview:
-
Module 2: Work IDS, Log Scans, and Log Master Jobs
- Overview of work IDs:
- Names and contents
- Work ID security
- Overview of log scans:
- What is a log scan?
- Time frame definitions
- Filter definitions
- Reports from the log scan
- Output file definitions
- Log mark definitions
- Run time options
- Defining a log scan step:
- Log scan step process
- Define a log scan step
- Building and running Log Master jobs
- Building Log Master jobs
- Running Log Master jobs
- Cleaning up after a Log Master job
- Overview of work IDs:
-
Module 3: Problem Transactions and Automated Drop Recovery
- Backing out problem transactions:
- Overview of backing out transactions
- Solutions for handling problem transactions
- Backout procedure Tasks
- Analysis of problem transactions
- Backout Integrity checking
- Using UNDO SQL
- Using REDO SQL
- Overview of automated drop recovery:
- Why use automated drop recovery
- Automated Drop Recovery
- The Overall Process
- Identifying objects to recover
- Automated drop recovery outputs
- Examples of a drop recovery report
- BMC AMI Recover features that Log Master uses
- Backing out problem transactions:
-
Module 4: Auditing and Data Migration
- Auditing data changes:
- Overview of auditing log information
- Summary of default reports
- Log information reports
- Performance reports
- Miscellaneous reports
- Overview of creating report templates
- Auditing Db2 catalog activity
- Defining a default report
- Data Migration:
- Data migration with Log Master
- Migration overview and considerations
- Ongoing process
- Using Log Master for data migration
- Overview of High-speed Apply Engine:
- What is High-speed Apply Engine?
- High-speed Apply Engine features and functions
- When to use the High-speed Apply Engine feature?
- Auditing data changes: