Database version control with IBM Optim Database Administrator V2.2

Enhance collaboration and ensure an audit path

From the developerWorks archives

Carolyn Henry, Marcia Miskimen, Jayashree Ramachandran, and Sailaja Bandlamoori

Date archived: January 12, 2017 | Last updated: July 30, 2009|First published: April 26, 2007

Have you ever wondered when the database was changed? With Optim Database Administrator wonder no more! IBM Optim Database Administrator (ODA) helps you keep track of changes, work seamlessly with other team members, reverse or undo changes, and audit any changes made to your database. This article describes a scenario where the DBA organization uses ODA along with the Eclipse Team project to enhance their collaboration and ensure a consistent audit path. Learn about connecting to a library control system and saving change management projects, models, and scripts in library control, as well as auditing the changes. Also, discover how to retrieve files from library control and use a change management script to undo the change.

Note: This article is an update of a previously published article about DB2 Change Management Expert, which was updated for Data Studio Administrator in August 2008. This version of the article reflects the new name as of June 2009, IBM Optim Database Administrator, and other changes that are available with Option Database Administrator, Version 2.2.

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 steps and illustrations may have changed.

Zone=Information Management
ArticleTitle=Database version control with IBM Optim Database Administrator V2.2