Getting started with the Control Center

Use the Control Center to manage systems, DB2 Universal Database instances, DB2 for OS/390 subsystems, 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 DB2 Universal Database systems, instances, and databases to the object tree
• Adding DB2 for OS/390 systems to the object tree
• Changing the default userid and password
• Creating database objects
• Customizing the columns in the contents pane
• Displaying objects in the Control Center
• Dropping objects
• Estimating space requirements for tables and indexes
• Filtering objects in the contents pane
• Filtering an object
• Finding objects in the contents pane
• Generating DDL for database objects
• Locating an object
• Obtaining DB2 diagnostic information
• Opening new Control Centers
• Performing administrative tasks on Control Center objects
• Refreshing objects in the Control Center
• Setting global properties for the administration tools and for replication tasks
• Showing commands or SQL
• Showing related objects
• Shutting down DB2 tools
• Sorting objects in the contents pane
• Testing and updating multiple databases
• Using SmartGuides to perform tasks quickly and easily

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 (formerly Visual Explain)

Monitoring Performance

• Changing a performance monitor
• Copying a performance monitor
• Creating a performance monitor
• Viewing collected performance data

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.