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 later database servers.
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, Windows 2000, 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.
The DB2 Control Center uses stored procedures to deliver many of its management functions. Therefore, for the Control Center to function properly each DB2 for OS/390 server that will be managed from the Control Center needs to have stored procedures enabled and the proper stored procedures installed on that server.
For more information on applying service and required Function Modification Identifiers, refer to the DB2 for OS/390 Program Directory.
Before you can work with a server and its databases you will need to catalog information about the server on the Control Center workstation. The DB2 Control Center only works with servers and databases that are cataloged on the workstation where the Control Center is running. The easiest way to accomplish this on Windows and OS/2 workstations is to use the DB2 Client Configuration Assistant (CCA).
Once the Control Center is running, start by clicking on the plus sign next to the server you want to administer. Select the database or connectivity server objects that you want to administer and right click on the object to work with object properties or to execute actions on the object. You can invoke the online help by clicking Help, or by pressing F1 at any time.
For more information about using the Control Center to administer DB2 for OS/390, refer to the following online resource: http://www.ibm.com/software/data/db2/os390/v6facts/db2cc.html
For complete information about DB2 for OS/390 Version 6, refer to the online library: http://www.ibm.com/software/data/db2/os390/v6books.html
For more information about stored procedures and the Control Center for OS/390, go to: http://www.ibm.com/software/data/db2/os390/cc390/