FAQ

Here are some answers to the most frequently asked questions about the BMC AMI Log Master for Db2 product.

For information about using this documentation portal, see About this documentation.

What is BMC AMI Log Master for Db2?

BMC AMI Log Master for Db2 is a tool that reads Db2 logs to help you recover data, audit changes, generate SQL/DDL, create logical logs, and migrate data across environments.

What are the primary use cases for Log Master?

Recovery of dropped objects, undo and redo transactions, auditing changes, generating logical logs, migrating data, and analyzing performance trends.

What interfaces does Log Master provide?

Log Master is accessible through ISPF panels and a batch JCL interface.

Does Log Master support data-sharing environments?

Yes, it works seamlessly across Db2 data-sharing groups.

Recovery and transaction management

Can Log Master recover dropped tables or indexes?

Yes, it can generate data definition language (DDL) and SQL from log records and apply them using High-speed Apply Engine.

Can I generate DDL for dropped objects?

Yes, Log Master can generate DDL statements for objects that were dropped.

Does Log Master support undoing or redoing transactions?

Yes, you can generate UNDO or REDO SQL scripts to reverse or reapply changes.

Can I automate recovery tasks?

Yes, you can define log scans and generate SQL/DDL for automated recovery.

How do I validate recovery or migration results?

Run an audit report and review the logical log or SQL output to confirm that the expected changes were applied correctly.

Auditing and compliance

How does the auditing feature work?

You can define filters (by user, table, plan, column, values) and produce detailed, filterable audit reports. You can also generate logical logs as permanent audit artifacts.

What filters can I use in a log scan?

You can filter by user ID, table name, plan name, column, or specific values.

Can I customize report formats?

Yes, you can use default formats or customize them to include specific details.

Does Log Master support compliance requirements?

Yes, it generates audit-ready reports and logical logs for regulatory compliance.

Can I generate logical logs for permanent audit records?

Yes, logical logs provide a portable, published-format record of database changes.

Logical logs

What is a logical log?

A logical log is a portable, published-format record of database changes that includes before and after images of data.

Can logical logs be reused?

Yes, you can reuse logical logs as input for subsequent jobs to avoid rescanning the Db2 log.

Can I include DDL objects in logical logs?

Yes, you can optionally include DDL objects when generating logical logs.

Does Log Master support XML data in logical logs?

Yes, it provides options like XMLSTRING for handling XML data during migration.

Data Migration

Can Log Master migrate data across Db2 environments?

Yes, it generates SQL and load files compatible with IBM LOAD, BMC LOADPLUS, or BMC AMI Load for Db2.

What outputs can Log Master generate for migration?

It can generate SQL undo/redo scripts, load files, and logical logs.

Does Log Master require additional utilities for migration?

Load files can be processed by IBM LOAD, BMC LOADPLUS, or BMC AMI Load for Db2. High-speed Apply Engine is included for SQL.

What is High-speed Apply Engine and how does it help?

High-speed Apply Engine applies SQL or logical logs quickly and reliably for recovery and migration.

Performance and monitoring

Can Log Master analyze performance trends?

Yes, it provides reports on commit and rollback frequency and image copy statistics.

What performance reports are available?

You can generate commit or rollback frequency, image copy frequency, and subsystem log status.

How do I monitor subsystem log status?

Log Master displays Db2 subsystem log status and supports data-sharing environments.

FAQ