IBM GC09-2830-00 Server User Manual


 
Appendix B. Using the Control Center to Administer DB2
for OS/390 and DB2 Connect Enterprise Edition servers
DB2 Control Center is an easy to use application provided as part of the DB2
Administration Client. The Control Center gives database administrators a
powerful tool for managing DB2 Family databases. In Version 6, the Control
Center has been greatly enhanced to deliver new management functions to
database administrators who need to manage DB2 for OS/390 V5.1 and V6.1
database servers. Version 6 of the Control Center has also been enhanced to
manage operational and performance characteristics of DB2 Connect
Enterprise Edition connectivity servers. The combination of DB2 for OS/390
server management and new DB2 Connect monitoring support provide
complete end-to-end administration and monitoring for desktop and web
applications that work with DB2 for OS/390 servers.
The DB2 Control Center uses the familiar explorer interface to allow
database administrators to easily navigate between different database servers
and the database objects they manage. Context sensitive right-mouse activated
menus provide administrators with the ability to change attributes of database
objects and to launch commands and utilities. Database objects are presented
in a consistent fashion for all DB2 family servers. This greatly reduces the
amount of learning that is required for administrators who need to manage
both DB2 for OS/390 and DB2 Universal Databases on Windows NT, UNIX
and OS/2 servers. While the Control Center preserves consistency across
servers it does not hide capabilities that are unique to each DB2 server. This
gives database administrators the power to perform all aspects of their tasks.
The ability to manage DB2 Connect connectivity servers is delivered through
management of user connections and by keeping vital statistics on various
performance aspects of the connectivity server. For example, database
administrators can easily view all of the users connected through a particular
DB2 Connect server, and their connection characteristics. Administrators can
also collect load and performance information such as the number of SQL
statements and transactions executed, number of bytes sent and received,
statement and transaction execution times and much more. Collected data can
be displayed using easy to understand live graphs.
© Copyright IBM Corp. 1993, 1999 139