Track the data manipulation language operations in your DB2 database

Protect against data loss using DB2 Recovery Expert

From the developerWorks archives

Amol D. Barsagade

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=309959
ArticleTitle=Track the data manipulation language operations in your DB2 database
publish-date=05222008