Version 5
|
|
Version 5
|
The Control Center (called Database Director in previous releases) has been significantly enhanced to provide greater ease of use. An administrator of a DB2 database is provided with the tools necessary to set up, manage, monitor, and tune the database. You can manage a stand-alone database, or multiple remote databases from a single point of control. In addition to management of database instances, databases, and table spaces, Control Center now includes management functions for schemas, tables, views, indexes, users, user groups, user-defined types, user-defined functions, triggers, and stored procedures, as well as the ability to discover databases on the systems being managed. The ability to explain SQL graphically has been enhanced.
Also new in Version 5 is a built-in Scheduler that allows a job to run unattended at a given time, every x hours / days / weeks / months, multiple times a week, or multiple times a month.
The Control Center now includes support for data replication setup, allowing registration of replication sources and definition of replication subscriptions. This function is part of the DB2 base engine.
Monitoring capabilities provide early warning of potential problems, or automated actions to correct problems discovered without human intervention.
The Control Center runs on OS/2, Windows NT, Windows 95, and Windows 98 operating systems, from which you can administer DB2 databases on OS/2, Windows NT, AIX, HP-UX, and the Solaris Operating Environment and other UNIX operating systems.
In addition to the function described above, there is support for the management of DB2 Universal Database Extended Enterprise Edition objects. There are additional performance monitoring views to monitor these objects.
See the online help that accompanies the database administrative tools for instructions for using the tools. See the Administration Getting Started for an introduction to DB2 database administration using the database administrative tools.
See "Web Control Center" for information on the Control Center support available in Version 5.2.
The Control Center has been further enhanced through the inclusion of SmartGuides, which step you through a task. SmartGuides are included for database performance configuration, create/restore/backup database, create table space, and create table.
The new Portable Snapshot function in Visual Explain makes the explain snapshot from any operating system usable by Visual Explain on any other operating system. For example, an HP-UX snapshot can be viewed with a Windows NT client.
See the online help that accompanies Visual Explain for instructions on how to use the tool.
The Command Center provides an interactive window that lets you perform tasks such as:
For complete information on all the commands see the Command Reference and SQL Reference. The DB2 Client Application Enabler contains a subset of the Command Center functions. See the Quick Beginnings book for your operating system for details.
See the online help that accompanies the Command Center for instructions on how to use the tool.
The Command Line Processor (CLP) continues to be available on all operating
systems.
 |
Version 5.2
|
The Web Control Center is the Java port of the DB2 Universal Database Control Center. It eliminates the need to install the Client Application Enabler on your administrative workstations and gives you the ability to administer DB2 Universal Database over an intranet.
The Web Control Center's design is almost identical to that of Version 5, but it provides you with a more flexible network centric administration environment. It is implemented as a Java applet that uses DB2's JDBC support. It runs from any Java-enabled Web browser that supports the Java Development Kit 1.1.5. See "Web Control Center Installation and Configuration" for details on installing, configuring, and using the Web Control Center.
The NetQuestion Search Service, in combination with the Web Control Center, gives easy access to the DB2 Universal Database information library. See "Enabling the Web Control Center Remote Documentation Searches" for details on installing and using the search function.