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 AUTOCONFIGURE as an option on
the CREATE DATABASE command. You can display the
recommended values or apply them by using the APPLY option on the CREATE
DATABASE command. The recommendations are based on input
that you provide and system information that the advisor gathers.
- You can use the Configuration Assistant to configure and maintain your
database objects, add new objects, bind applications, set database
manager configuration parameters, and import and export configuration
information. To open the Configuration Assistant, invoke the
db2ca command. For instance configuration, the
Configuration Assistant helps you to set database manager configuration
parameters, set DB2 registry variables, configure another instance,
or reset the configuration.
- 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.