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

Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.