Administration Guide

Setting DB2 Registry Variables at the User Level

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

DB2 has a caching mechanism. The DB2 profile registry variables at the user level are cached on the local machine. 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
```

[ Top of Page | Previous Page | Next Page ]