Managing communications on the server

The Control Center allows you to view, update, and reset server protocol settings in the database manager configuration file. 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. By default, the setup program automatically detects and configures most communication protocols that it detects on your system.

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

• 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 Server Profile option from the pop-up menu.

Viewing SQL access plans using Visual Explain

You cannot use Visual Explain to generate access plans on host or System i™ databases.

• 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.

Parent topic: DB2 Connect