vView the details of database objects. You can look at a table’s constituent columns and see the current state of a database.
vManage database objects. You can create, alter, and drop databases, table spaces, tables, views, indexes, triggers, and schemas. You can also manage users.
vManage data. You can load, import, export, and reorganize data. You can also gather statistics.
vPerform preventive maintenance by backing up and restoring databases or table spaces.
vConfigure and tune instances and databases.
vManage database connections, such as DB2 Connect™ servers and subsystems.
vManage applications.
vLaunch other tools such as the Command Center and the Health Center.
Figure 4. Control Center advanced view with a table selected
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.
44Getting started with DB2 installation and administration
