Quick Beginnings for UNIX

Administering Instances and Databases with the DB2 Administration Tools

You can administer local or remote servers using the DB2 Administration Tools. Use the Control Center to perform administration tasks such as configuring DB2 instances and databases, backing up and recovering data, scheduling jobs, and managing media, all from a graphical interface.

The Control Center for Version 6 has additional support for DB2 UDB for OS/390.

Note:

This option is only available on DB2 Enterprise Edition, DB2 Enterprise - Extended Edition, DB2 Connect Personal Edition, and DB2 Connect Enterprise Edition.

If you want to access DB2 for OS/390 functions from the Control Center:

1. Verify the following information with your systems administrator:

   1. You have a DB2 for OS/390 license (Version 5 or later).

   2. You are using DB2 Connect Enterprise Edition.

2. Apply a function modification identifier. Read the DB2 for OS/390 Program Directory. The program directory identifies and describes the contents of FMIDs for each tape or cartridge.

3. Apply any additional service to DB2 as described in the program directory.

4. Ensure that you enabled the stored procedures address space.

Managing Communications on the Server

The Control Center allows you to view, update, and reset server protocol settings. These functions are accessed by clicking with the right mouse button on an instance and selecting the Setup communications option from the pop-up menu. This tool helps database administrators to:

• Configure communication parameters in the database manager by clicking with the right mouse button on an instance and selecting the Configure option from the pop-up menu.
  

  By default, the setup program automatically detects and configures most communication protocols that it detects on your system.

• Export database information in a profile that can be used to configure clients by clicking with the right mouse button on a system and selecting the Export option from the pop-up menu.

For information on how to configure server communications, refer to the Installation and Configuration Supplement.

Monitoring Databases Using DB2 Performance Monitor

With the DB2 Performance Monitor, you can:

• Identify and analyze performance problems in database applications or the database manager.

• Use the early warning system to detect potential problems.

• Automate actions to correct problems that are discovered.

• Define your own statistics, in addition to the default set that is provided.

You can choose to monitor the current state of database activity or collect information when specific events occur. The Performance Monitor allows you to capture point-in-time information at specified intervals. The Event Analyzer allows you to view information about the occurrence of events such as deadlocks and transaction completions.

For additional information, refer to the Administration Guide or the online help.

You are also able to use the Windows NT Performance Monitor to monitor both database and system performance. For information on how to register DB2 resources and to use the Windows NT Performance Monitor, refer to the Administration Guide.

Viewing SQL Access Plans Using Visual Explain

Visual Explain helps database administrators and application developers to:

• View the access plan chosen by the database manager's optimizer for a given SQL statement.

• Tune SQL statements for better performance.

• Design application programs and databases.

• View all the details of an access plan, including the statistics in the system catalogs.

• Decide whether or not to add an index to a table.

• Identify the source of problems by analyzing the access plan or performance of SQL statements.

• Use the portable snapshot function to view snapshots from any remote DB2 server.

• Display access plans for queries on all supported DB2 configurations.

For additional information, refer to the Administration Guide or the online help.

Note:

You cannot use Visual Explain to administer host databases.

[ DB2 List of Books | Search the DB2 Books ]