Filter
Top Products
v View the details of database objects. You can look at a table’s constituent
columns and see the current state of a database.
v Manage database objects. You can create, alter, and drop databases, table spaces,
tables, views, indexes, triggers, and schemas. You can also manage users.
v Manage data. You can load, import, export, and reorganize data. You can also
gather statistics.
v Perform preventive maintenance by backing up and restoring databases or table
spaces.
v Configure and tune instances and databases.
v Manage database connections, such as DB2 Connect
™
servers and subsystems.
v Manage applications.
v Launch other tools such as the Command Center and the Health Center.
The main Control Center window is split into three sections, or panes. On the left
side, there is an Object Tree. This tree displays all of your databases and their
constituent objects (such as tables, views, and indexes).
When you select any one of the available database objects or object folders in the
Object Tree, the Contents Pane, occupying the top half of the right side of the
Control Center window, fills with a list of the relevant objects. For example, by
selecting a database’s Table folder in the object tree, you will fill the Contents Pane
with all of that database’s tables, as well as some information about each.
There is, however, more detail about any given object than will fit in the Contents
Pane; the bottom pane on the right side, the Object Details Pane provide the
additional information. Clicking on an object in the Contents Pane will bring up
detailed information about that object in the Object Details Pane. When you click
on a table object in the object list, you will see a listing of that table’s columns, as
well as other table attributes and some actions that are relevant to tables.
Figure 4. Control Center advanced view with a table selected
44 Getting started with DB2 installation and administration