BMC Log Master for DB2

Enhance transaction recovery, migrate data quickly, and audit change

IT organizations need to be able to see who is updating DB2 on z/OS data, to migrate data, and to recover from bad transactions - safely and efficiently - with little or no downtime. The DB2 log contains information about every change made to DB2, but it can be difficult to understand and manipulate log data.  How can you ensure the integrity and availability of DB2 data?

BMC solution

BMC Log Master for DB2 unlocks the resources embedded in DB2 logs and enables easy access to logs. With BMC Log Master for DB2, you can audit data changes, undo bad transactions, and migrate DB2 on z/OS data to other DB2 or RDBMS applications with no outage. The product can use the information from the DB2 log records to generate SQL and DDL statements that you can use for data migration for data warehousing and decision support.

Features and benefits

• Reduces the costs of processing DB2 log data with sophisticated filtering functionality
• Improves performance of data migration with the High Speed Apply engine
• Improves availability by enabling back out of individual transactions
• Improves productivity by providing a user interface to allow access to DB2 log data for reporting, migration, and recovery.
• Mitigates risk by reporting who changed DB2 data and structures, and by automating recovery of accidentially dropped DB2 objects

Key differentiators

• Audit reporting - from summary to detail level can identify exactly who changed data and what they changed
• Transaction backout - ability to undo a bad transaction without recovering the entire application
• Data migration - allows DB2 on z/OS data to be ported to other platforms 
• Drop recovery - allows recovery of all objects that were accidentally dropped
• Logical Log - allows creation of an extract of DB2 log data for subsequent purposes (such as storing audit information for several years)