This lesson covers the ways you can improve database performance. You will learn how to improve database performance by administering the following:
Database manager configuration parameters, which enable you to control your database environment
Database configuration parameters, which enable you to control a specific database
Configuration Advisor, which enables you to direct DB2 to set several configuration parameters to understand your database environment
You can further tune your environment with environment variables and registry values. Today you learn how to set these values and whether you need to set a value at an instance or global level.
DB2 provides the Configuration Advisor to help ...