meta name="google-site-verification" content="5WnqBAqGhoY5qGR6vWeOU46UM0maXZMbAaLr-28Vvhw" /> learning db2: DB2 Graphical Tools

DB2 Graphical Tools

DB2 Graphical Tools

DB2 Express includes an easy-to-use suite of tools to help you manage your database without having to learn the DB2 command-line environment. Over the course of this book you will see more of the capabilities of these graphical tools. This section gives you an initial look at two of these tools—the DB2 Control Center and the Command Editor—and explains what you can do with them.

The DB2 Control Center is used to administer DB2. Using the Control Center you can create, modify, and manage databases and their associated objects (tables, indexes, etc.) as well as launch many other tools to guide you through a vast array of tasks and activities.
The Control Center can be launched in a number of ways:
From the Windows Start menu entry
From the DB2 icon in the Windows system tray
  • By executing db2cc on a command prompt
  • By clicking on the Control Center icon in the toolbar of any of the other DB2 tools
The first time the Control Center loads, you will see the Customize dialog (Figure 2.12) asking you which Control Center view you would like to use. The Control Center is a single point of access to a vast array of functionality. Exposing all the options and advanced features to new users, however, can be a bit overwhelming. Therefore, unless you have prior experience with DB2, we recommend that you select the Basic view, which will display only the essential database objects and features (as opposed to the default Advanced view setting).
After a view has been selected, the Control Center will continue to use that setting until you reinvoke the dialog and change it. When you have more experience with the Control Center, you can further customize it to show only those items and features you need.
If you choose the Advanced view, all available folders, objects, features, and functions will be displayed. The Custom view allows you to configure a customized view of the Control Center that shows only what you want to see. By clicking the Modify button, you can hide or show folders, objects, and their associated context menu items.
If you want to reinvoke the Control Center View dialog, select the Customize Control Center option (Figure 2.13) from the Tools menu. Or you can click on the Customize Control Center link in the object details panel when the root of the object tree (labeled "Control Center") is selected.
No matter which Control Center view is selected, the main interface will be laid out in three main sections (Figure 2.14):
  • Left frame, object tree
  • Upper-right frame, object listing
  • Lower-right frame, object details


0 comments:

Post a Comment