The DB2 Change Management Expert user interface

DB2® Change Management Expert is based on Eclipse, an open source Integrated Development Environment (IDE).

DB2 Change Management Expert opens in the Eclipse Workbench window, which consists of perspectives, views, and editors. A perspective is a particular set of views and editors.

You typically use a view to navigate information within the Workbench, open an editor, or display properties for the active editor. The changes that you make in a view are saved immediately.

You use an editor to browse or modify a resource. Modifications made in an editor follow an open-save-close lifecycle model.

The following figure shows that the DB2 Change Management Expert interface uses the Data perspective. The figure also provides an example of some of the views and editors in this perspective. The Database Explorer view, which displays the connections to databases, is in the lower left corner. The Project Explorer view, which shows the resources in the various projects, is in the upper left corner. More views, such as Properties, Tasks, and Problems, are located along the bottom. The Deployment Script Editor is located in the editor area in the middle, and it is the active editor. The Data Model Editor is tiled behind the Deployment Script Editor.Start of change
Figure 1. The DB2 Change Management Expert integrated development environmentThe figure contains a screen capture of the DB2 Change Management Expert graphical user interface. The text that introduces the figure provides a description of the various components of the interface.
End of change

Views

The main views that DB2 Change Management Expert uses include:
Database Explorer
Displays database connection information. You can use this view to manage database connections and view objects in your databases.
Data Project Explorer
Displays your database management projects, which contain the resources (models, scripts, and other files) that are required to make changes to a database.
Outline
Displays an outline of the resource file that is currently open in the editor area and lists structural elements. The contents of the Outline view are specific to the editor. The Outline view is linked to the Data Model Editor, the Diagram Editor, and the Change Command Editor.
Properties
Displays property names and values for a selected item. For example, for a connection that is selected in the Database Explorer view, the Properties view displays information about that connection. For a table that is selected within a model in the Data Project Explorer view, the Properties view displays information about the columns, the partition key, and the table space.
Tasks
Displays system-generated problems, warnings, and errors. You can add your own entries to the table to build a list of tasks or to-do items.
Error Log
Displays all the internal warnings and errors that are issued by the Eclipse platform and by plug-in development code.
Problems
Displays problems with the validity of models, syntax errors in change commands, and the validity of deployment scripts. When you double-click a problem in the list, the editor is opened at the location of the problem.
Model Report
Displays the details about the relationship between an object and its dependent objects when you perform impact analysis to determine the effects of changing an object.
Data Output
Displays the results of deploying change commands and scripts to the database.
Bookmarks
Displays user-defined bookmarks. For example, you can bookmark the objects in a model from the Data Model Editor or the Outline view to make it easier to find the object later.

Editors

The main editors that DB2 Change Management Expert uses include:
Deployment Script Editor
Presents a consolidated way to work with the changes that you want deploy to your database. The Deployment Script Editor uses these tabs that contain the actions that you can use to access objects and perform database changes:
  • Data Model tab
  • Change Commands tab
  • Undo Scripts tab
  • XML Source tab
  • Multiple Deployment tab
Data Model Editor
Edit schema definitions.
Diagram Editor
Visualize or edit the schema definitions of a model through its diagram.
Comparison Editor
Compare two models and merge the differences between them.
Change Command Editor
Edit change commands.

Tips

The following tips can help you work with views and editors:
  • Two or more editors can be in the editor area. They are tiled by default.
  • You can rearrange views and editors to customize the layout. However, you cannot drag views into the editor area, nor can you drag editors outside the editor area.
  • Instead of closing views, you can use Fast views, which are hidden views, to free up screen space.
  • You can open a view by selecting Window > Show View.
  • You can reset the Data perspective to its default views and layout by selecting Window > Reset Perspective


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.