Key concepts

The following key concepts apply throughout the system and provide the foundation for how log data is scanned, analyzed, and transformed for recovery, auditing, and migration.

This section introduces the key ideas that support the product’s functionality.

• Log scans
  A log scan is the process of reading active and archive Db2 logs within a specified time frame and applying filters to extract relevant information. You can generate outputs such as reports, SQL, load files, and logical logs in a single pass and customize defaults for each action.
• Logical logs
  A logical log is a portable, published-format record of database changes that includes before-and-after images of data. You can create logical logs for auditing or recovery, reuse them as input to avoid rescanning, and optionally include data definition language (DDL) objects.
• SQL, DDL, and load generation
  You can generate SQL statements for undo and redo operations, produce DDL for structural changes, and create load files that can be processed by Db2 utilities such as IBM LOAD, BMC LOADPLUS, or BMC AMI Load for Db2.
• High-speed Apply Engine
  The High-speed Apply Engine runs SQL or applies logical logs quickly and reliably. It integrates with Log Master to streamline recovery, migrations, and logical backout processes.
• Recovery tasks
  You can identify and analyze problem transactions, automate recovery of dropped objects, generate DDL and SQL, and determine quiet points to define safe recovery windows.
• Auditing and reporting
  You can search the Db2 log using filters such as user, table, plan, column, or values, generate detailed reports and create logical log files as permanent audit records. Reports can include committed, aborted, and in-flight transactions.
• Subsystem visibility
  You can view Db2 subsystem log status, obtain performance and statistical reports such as commit, rollback, and image copy frequency, and work seamlessly in Db2 data-sharing environments.