DB2 Connect User's Guide

Administration Utilities

The following utilities are available to help a DB2 Connect administrator:

• The Command Line Processor lets you issue SQL statements against a host or AS/400 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.
• Import and export utilities let you load, import, and export data to and from a file on a workstation and a host or AS/400 database server database. These files can then be used for importing data into databases, spreadsheets, and other applications running on your workstation. For more information on import and export utilities, refer to the Data Movement Utilities Guide and Reference.
• Users of DB2 Connect Enterprise Edition running on Windows NT and Windows 2000 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 database objects, such as tables, views, buffer pools, and threads. For more information on managing DB2 for OS/390 systems from the DB2 Control Center, refer to the Application Development Guide.

For more information about these utilities, see Administration Utilities.

In addition, the database system monitor utility lets the system administrator monitor system connections. 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 AS/400 database server. For more information, see Database System Monitor.