Setting Db2 registry variables at the user level in the LDAP environment

Under the LDAP environment, the Db2 profile registry variables can be set at the user level which allows a user to customize their own Db2 environment.

About this task

Db2 has a caching mechanism. The Db2 profile registry variables at the user level are cached on the local computer.

The cache is refreshed when:
  • You update or reset a Db2 registry variable at the user level.
  • You issue the command to refresh the LDAP profile variables at the user level:
       db2set -ur

Procedure

To set the Db2 profile registry variables at the user level, use the -ul option:
   db2set -ul variable=value
Note: This is not supported on AIX® or Solaris operating systems.
If the -ul parameter is specified, Db2 always reads from the cache for the Db2 registry variables.