Improve performance and self-configure with the automated Configuration Advisor

Newly created DB2 9 databases are now self-configuring and self-maintaining by default, which means that at database creation time, you no longer need to worry about memory management, storage management, performance tuning, or database maintenance planning.

Version 8 of DB2 introduced the Configuration Advisor that detected the system and database characteristics – CPUs, memory, database size, number of tables, etc. and recommended values for configuration parameters. DB2 9 goes even further – it runs the configuration advisor automatically, and makes some basic tuning decisions by default.

For example, it configures the size of the default buffer pool, I/O cleaners and I/O servers, etc. This initial automatic tuning means that your database will have better performance than a database created with the previous database configuration default values, enabling better out-of-the-box operation.