Getting started with the Control Center

Use the Control Center to manage systems, DB2 Universal Database instances, DB2 Universal Database 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, jobs, and scripts, perform data warehousing tasks, create stored procedures, and work with DB2 commands.

Note:

Information prefixed with pertains only to partitioned database environments.

Tasks

Working with objects in the Control Center

• Adding DB2 Universal Database systems, instances, and databases to the object tree
• Adding DB2 Universal Database for OS/390 systems to the object tree
• Adding DB2 Server for VSE & VM to the object tree
• 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
• Limiting the number of objects displayed in the Control Center.
• Finding objects in the contents pane
• Generating DDL scripts 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
• Typing characters using the Alt-Gr key
• Using wizards 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
• Saving files using the Control Center file extension

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

Working with data warehouses

• Working with Data Warehouses in the Data Warehouse Center

Building stored procedures

• Information on Stored Procedure Builder

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.

Accessing custom controls with the keyboard

You can use the keyboard to access controls found on the graphical user interface. The following two controls are unique to DB2. Here is how you access them using the keyboard:

• 
  
  

  To access this button using the keyboard, use the Tab key until the button is selected then press Enter

• The date entry field

  To access this feature using the keyboard, use the Tab key until the entry field is selected, then type the date in the entry field.