Administration Guide

Parameter Details by Function

This following sections provide additional details to assist in understanding and tuning the different configuration parameters. This discussion of the individual parameters is organized based on their function or purpose:

• Capacity Management

• Logging and Recovery

• Database Management

• Communications

• Parallel

• Instance Management.

The discussion of each parameter includes the following information:

Configuration Type

Indicates which configuration file contains the setting for the parameter:

• Database manager (which affects an instance of the database manager and all databases defined within that instance)

• Database (which affects a specific database)

Parameter Type

Indicates whether or not you can change the parameter value:

• Configurable

  A range of values are possible and the parameter may need to be tuned based on the database administrator's knowledge of the applications and/or from benchmarking experience.

• Informational

  These parameters are changed only by the database manager itself and will contain information such as the release of DB2 that a database was created under or an indication that a required backup is pending.

[ DB2 List of Books | Search the DB2 Books ]