When you start a new DB2® instance,
there are a number of steps that you can follow to establish a basic
configuration.
- You can use the Configuration Advisor to obtain recommendations
for the initial values of the buffer pool size, database configuration
parameters, and database manager configuration parameters. To use
the Configuration Advisor, specify the AUTOCONFIGURE command
for an existing database, or specify the AUTOCONFIGURE parameter
on the CREATE DATABASE command. You can display
the recommended values or apply them by using the APPLY parameter
on the CREATE DATABASE command. The recommendations
are based on input that you provide and system information that the
advisor gathers.
- Consult the summary tables (see "Configuration parameters summary")
that list and briefly describe each configuration parameter that is
available to the database manager or a database. These summary tables
contain a column that indicates whether tuning a particular parameter
is likely to produce a high, medium, low, or no performance change.
Use these tables to find the parameters that might help you to realize
the largest performance improvements in your environment.
- Use the ACTIVATE DATABASE command to activate
a database and starts up all necessary database services, so that
the database is available for connection and use by any application. In
a partitioned database environment, this command activates the database on all database partitions
and avoids the startup time that is required to initialize the database
when the first application connects.