Customizing application behavior using registry variables

DB2 provides many registry variables that can affect the database environment. If configured properly, they can have a significant impact on application performance. All registry variables are effective at instance level, which means they will affect all databases in a given instance. In this recipe, we will discuss some registry variables which are relevant from an application-behavior perspective. Most of the time, application developers do not have permissions to change any registry variable, but we should know what impact they can have on the way an application behaves.

Getting ready

Registry variables operate at instance level, so we need the SYSADM authority to view or modify their values.

How to do it...

The following steps discuss the most important registry variables that can have a significant impact on application performance and behavior:

Note

Disclaimer: Registry variables are very sensitive and can behave differently in different...