Instance configuration

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.