IBM GC09-2830-00 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