DB2 Version 9.7 for Linux, UNIX, and Windows

DB2 Connect administration utilities

Important: The Control Center and its associated components have been deprecated in Version 9.7 and might be removed in a future release. For more information, see Control Center tools have been deprecated.
The following utilities are available to help a DB2 Connect™ administrator:
  • The Command Line Processor (CLP) or CLPPlus. You can use the CLP or CLPPlus to issue SQL statements against an IBM mainframe database server database. The SQL statements are issued on the database that you specify.
    Note: CLPPlus for administration is available in the IBM® data server driver package and does not require DB2 Connect server modules to be installed.
  • The DB2® Command Center® provides a graphical interface to the Command Line Processor (CLP).
  • Import and export utilities let you load, import, and export data to and from a file on a workstation and a IBM mainframe database server database. These files can then be used for importing data into databases, spreadsheets, and other applications running on your workstation.
  • If you are running a DB2 Connect server product, you can use the Event Viewer and the Performance Monitor. Using the Event Viewer, you can view exception events logged by DB2 Connect. Using the Performance Monitor, you can monitor and manage the performance of DB2 Connect servers either locally or remotely.
  • The DB2 Control Center lets you administer and monitor all aspects of DB2 Connect servers. It also allows administrators to work with DB2 for z/OS® database objects, such as tables, views, buffer pools, and threads.
  • The database system monitor utility lets the system administrator monitor system connections. This function is only available when DB2 Connect is acting as server. This utility also helps the system administrator determine the source of an error. The system administrator can correlate client applications with the corresponding jobs running on the IBM mainframe database server.
Note: In previous releases, the DB2 Graphical Administration Tools, such as the Control Center, were supported on all platforms. As of Version 9, the DB2 Graphical Administration Tools are supported only on Windows x86, Windows x64 (AMD64/EM64T), Linux on x86, and Linux on AMD64/EM64T. For all platforms, you can use the DB2 Command Line processor (CLP) for administration purposes.