8.7  Database management tools

In this section we introduce the graphical tools available for managing MySQL 

and DB2 UDB database servers. Although you can do all the tasks in both the 

database from shell command prompt,

these tools play an important role in 

making the database administrators' job easier.

By default MySQL does not come with any control tool for database 

management, but MySQL AB provides MySQL Control Center, also known as 

MySQLCC for graphical administration of the MySQL server. Also, the 

SourceForge open source community provides a tool called phpMyAdmin, which 

is more popular, and can manage the MySQL server and database from the Web 

browser.

On the other hand, DB2 UDB supports impressive suite of tools for database 

management and services. All the daily database operations can be easily and 

effectively done using following GUI tools and wizards:

Control Center

The Control Center is a tool provided by DB2 UDB to manage systems, DB2 

instances, and database objects such as tables and views. It can be used to 

launch other centers and tools to help you optimize queries, jobs, and scripts, 

perform data warehousing tasks, create stored procedures, and work with 

DB2 commands. It can be opened by calling the 

db2cc

 command.

Command Center

DB2 UDB Command Center interface can be used to execute SQL 

statements and DB2 CLP commands, to execute operating system 

commands, to work with command scripts, and to view a graphical 

representation of the access plan for explained SQL statements. It can be 

launched by calling the 

db2cmdctr

 command.

Development Center

Development Center is easy to use interface for developing and debugging 

routines such as user defined functions and stored procedures. 

Project Deployment Center

This tool helps you deploy objects that you exported to a file system using the 

export wizard in the Development Center. This wizard can be launched using 

the 

db2dcdpl

 command.

Journal

The Journal is the monitoring tool for viewing historical information generated 

within the Control Center and its components. It historical information about 

tasks, database actions and operations, Control Center actions, messages, 

254 

MySQL to DB2 UDB Conversion Guide