Optim Database Administrator simplifies the process of managing your database objects by supporting instance and database management and by providing the ability to run database commands and utilities. It provides a simple user interface to invoke the database administration commands that you use to maintain and manage your database environment.
Task assistants guide you through the process of generating commands for many tasks. By using task assistants you can run the commands immediately, or you can save them as a script. For more information about task assistants, see Overview of database administration from the Data Source Explorer.
By understanding how to use the Administration Explorer view in conjunction with the Object List view, you can navigate between your databases and quickly display and find the database objects that you want. For more information, see Administration Explorer and the Object List overview.
Optim Database Administrator gives you the ability to view and manage privileges on database objects. For more information, see Managing privileges for data objects.
You can use the SQL and XQuery Editor to run DB2 administration commands, SQL scripts, and utilities from within the editor. For more information, see Invoking and running database administration commands.
Optim Database Administrator simplifies the process of managing database changes. You can change your database schemas by using either the Data Object Editor or the Change Management Script Editor.
While the Data Object Editor is optimal for making one change at a time in an iterative development process, the Change Management Script Editor provides more function. For example, you can make multiple changes at once to your test or production systems, preserve your data across database changes, review a summary of changes report, undo you database changes, and track your changes with a version control system.
Optim Database Administrator automatically generates commands to implement your changes, manage dependent objects, and takes resulting actions to address any side effects that are caused by schema changes. You can define changes to multiple objects, visualize your changes before you make them, and see the impact that those changes will have on other objects. Optim Database Administrator allows you to view commands before you deploy them against the your DB2 database. For more information, see Working with change management scripts.
Optim Database Administrator can also manage database objects in an Enterprise Server Edition (ESE) and Database Partitioning Feature (DPF) environment.
In addition to this overview, there are several annotated tours available to help you get started with Optim Database Administrator. For more information, see http://publib.boulder.ibm.com/infocenter/idm/docv3/topic/com.ibm.datatools.tours.dbadmin.doc/chxuctours.html.