Product overview

Related topics

BMC AMI Log Master for Db2 helps you access and use the Db2 log for purposes beyond restart and recovery. You can use it to retrieve detailed information from log records to support data migration, auditing, and advanced recovery, including innovative solutions for logical backout and recovery of application transactions.

Capabilities

BMC AMI Log Master for Db2 provides the following capabilities:

Capability	Description
Log scan definition	You can specify time frames and filters, scan active and archive logs, and build logical logs and outputs such as reports, SQL, and load files, with defaults that can be customized for each action.
Logical log output	You can generate published-format logical logs for use by applications or as audit records, reuse logical logs as input to avoid rescanning, and optionally include data definition language (DDL) objects.
SQL and load generation	You can produce SQL for undo and redo operations and data migration and create load files that can be processed by IBM LOAD, BMC LOADPLUS, or BMC AMI Load for Db2.
High-speed Apply Engine integration	You can apply generated SQL or logical logs with the included High-speed Apply Engine for fast and reliable execution.
Auditing reports	You can use standard report formats with granular filters, include completed transactions such as committed or aborted ones, and handle in-flight scenarios.
Subsystem visibility	You can display Db2 subsystem log status and work seamlessly across data-sharing environments.

Benefits

BMC AMI Log Master for Db2 has the following benefits:

You can accelerate recovery with precision by quickly locating problem transactions, automating drop recovery, and generating DDL and SQL needed to restore application state.
You can provide audit-ready governance by producing comprehensive, filterable reports and logical logs for compliance, security investigations, and operational transparency.
You can enable efficient data movement by migrating data across systems with generated SQL and load files, leveraging High-speed Apply Engine and mainframe utilities for performance.
You can deliver operational insights by understanding commit and rollback behavior and image copy frequency to improve resilience and planning.

User roles

Role	Responsibilities
Db2 DBA	Define log scans, analyze problem transactions, drive recovery and drop recovery, and produce audit artifacts
Application developer	Review audit outputs and logical logs to validate application changes and support logical backout when needed
System programmer	Configure product access, monitor usage, and align execution with subsystem and data-sharing settings
Security or compliance analyst	Use reports and logical logs to investigate activity by user, plan, or job and maintain audit trails

Key integrations

You can integrate BMC AMI Log Master for Db2 with the following BMC products:

High-speed Apply Engine—Applies SQL and logical logs generated by Log Master to streamline recovery and migration activities.
IBM and BMC load utilities—Processes Log Master load files with IBM LOAD, BMC LOADPLUS for Db2, or BMC AMI Load for Db2 for high-performance data movement.
Recovery Management for Db2 solution—Log Master (including High-speed Apply Engine) is a component of the broader solution with BMC AMI Recovery Manager, BMC AMI Recover, and BMC AMI Copy, providing integrated recovery capabilities.

Interfaces and components

BMC AMI Log Master for Db2 combines an intuitive online interface with robust engines to scan logs, generate outputs, and orchestrate apply operations.

Tool or system	Type	Description
Online interface and panels	Interface	Guides users to define time frames and filters, select outputs (reports, SQL, load files, logical logs), and submit jobs
High-speed Apply Engine	Component	Runs generated SQL and applies logical logs at scale for recovery and migration
Output generators	Component	Creates standard audit reports, SQL undo or redo sets, DDL, and load files, with defaults that can be tailored per action
Logical log facility	Component	Publishes structured logical logs for analytics, compliance, re-use in subsequent jobs, or as inputs to external programs