O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 20. Tuning DB2 Universal Database Performance

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required