IBM Optim Database Administrator overview

IBM® Optim™ Database Administrator is a powerful and flexible tool that helps you manage your database objects. It simplifies the process of comparing, identifying, analyzing, and implementing database schema changes.
You can use Optim Database Administrator to perform common database administration tasks within the Eclipse environment, such as:
  • Starting or stopping a DB2® instance
  • Backing up a database
  • Creating database objects
  • Modifying database objects
  • Changing configuration settings
  • Granting and revoking security privileges
  • Running DB2 commands and utilities
Optim Database Administrator provides an integrated end-to-end solution that enables you to seamlessly work with multiple products simultaneously.

Database administration

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.

Managing database objects

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.

Database object change management

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.

Important: To use the change management function in Optim Database Administrator, which includes the ability to use change managements scripts and the Change Management Script Editor, the Database Change Management feature must be installed and change management capability must be enabled. For more information, see Enabling change management capability.

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.


Feedback