Db2 registry and environment variables

Db2 database products provide a number of registry variables and environment variables that you might need to know about to get up and running.

To view a list of all supported registry variables, execute the following command:

db2set -lr

You must set values for registry variables that you want to update before you execute the db2start command.

The following table lists all registry variables by category.
Table 1. Registry and environment variables summary
Variable category Registry or environment variable name
General
System environment
Communications
Command-line
Partitioned database environment
Db2 pureScaleĀ® environment
Query compiler
Performance
Miscellaneous