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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved