Getting started with the Control Center

Use the Control Center to manage systems, instances, databases, and database objects, such as tables and views. In the Control Center, you can display all of your systems, databases, and database objects and perform administration tasks on them. From the Control Center, you can also open other centers and tools to help you optimize queries and work with DB2 commands, jobs, and scripts.

Note:

Information prefixed with pertains to partitioned database environments only.

Tasks

Working with objects in the Control Center

• Adding systems, instances, and databases to the object tree
• Creating database objects
• Displaying objects in the Control Center
• Pre-filtering tables and indexes before displaying them in the contents pane
• Dropping objects
• Opening new Control Centers
• Changing the default userid and password
• Performing administrative tasks on Control Center objects
• Refreshing objects in the Control Center
• Setting global properties for the administration tools and for replication tasks
• Shutting down DB2 tools
• Sorting objects in the contents pane
• Filtering objects in the contents pane
• Customizing the columns in the contents pane
• Finding objects in the contents pane
• Obtaining DB2 diagnostic information

Working with jobs and scripts

• Creating and running command scripts using the Script Center

• Creating and running SQL, DB2, and operating system commands using the Command Center

Optimizing SQL queries

• Analyzing SQL statements using Visual Explain

Finding information

• Looking up information in the DB2 library
• Getting online help and product information

The Control Center interface

The Control Center interface has five elements that help you define and manage systems and databases.

Menu bar

Use the menu bar to work with objects in the Control Center, open other administration centers and tools, and access online help.

Control Center toolbar

Use the toolbar icons above the object tree to access other functions, such as setting preferences and viewing job status, logs, and messages. These functions can also be selected in the View menu.

Object tree

Use the object tree to display and work with system and database objects.

Contents pane

Use the contents pane to display and work with system and database objects. The contents pane displays those objects that make up the contents of the object that is selected in the object tree.

Contents pane toolbar

Use the toolbar below the contents pane to tailor the view of objects and information in the contents pane to suit your needs. These toolbar functions can also be selected in the Edit menu and the View menu.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]