Track the data manipulation language operations in your DB2 database
Protect against data loss using DB2 Recovery Expert
From the developerWorks archives
Date archived: May 15, 2019 | First published: May 22, 2008
Protecting data against any failure is a huge challenge for the DBA at any organization. In production and 24x7 environments where databases are mission-critical, any data loss is unacceptable. To successfully perform point-in-time recovery, you must have sufficient information about all the Data Manipulation Language (DML) operations that have taken place. This article shows you how to keep track of all DML operations that occur against a database, even down to a specific table. Using the IBM® DB2® Recovery Expert (RE) tool and the db2la command, you can track DML operations along with the time that they occurred.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some content, steps, or illustrations may have changed.