• The Command Line Processor (CLP) lets you issue SQL statements against a host or System i™ database server database. It flows the SQL statements to the database that you specify.

• 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 host or System i 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 OS/390^® or 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 host or System i 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.

Parent topic: DB2 Connect

Related concepts
Database system monitor