DB2 Version 9.7 for Linux, UNIX, and Windows

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

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.

DB2 has a caching mechanism. The DB2 profile registry variables at the user level are cached on the local computer. If the -ul parameter is specified, DB2 always reads from the cache for the DB2 registry variables. The cache is refreshed when:

You update or reset a DB2 registry variable at the user level.
The command to refresh the LDAP profile variables at the user level is:
```
   db2set -ur
```