Installing and Configuring DB2 Clients

Controlling the DB2 Profile Registry

The DB2 profile registry stores DB2 registry values. The "levels" of registry values are as follows:

DB2 instance-level profile:: This profile contains instance level variable settings and overrides. Values defined in this level will override their settings in the global level.
DB2 global-level profile:: This profile contains system-wide variable settings. Any variable not defined in the node or instance levels will be evaluated at this level.

To modify registry variable values, use the db2set command. The syntax of the db2set command is as follows:

To set a parameter for the current instance, type:
```
   db2set parameter=value
```
To set a parameter's value for a specific instance, type:
```
   db2set parameter=value -i instance-name
```
To set a parameter at the global profile level, type:
```
   db2set parameter=value -g
```
Notes:
1. Some parameters will always default to the global level profile. They cannot be set at the instance or node level profiles. Examples of this are DB2SYSTEM and DB2INSTDEF.
2. On UNIX, you must have system administrative (SYSADM) authority to change registry values for an instance. Only users with root authority can change parameters in global-level registries.
To delete a parameter's value at a specified level, you can use the same command syntax to set the parameter but specify nothing for the parameter value. For example, to delete the parameter's setting at the node level, type:
```
   db2set parameter= -i instance-name node-number
```
To explicitly unset a parameter's value at a specified level and prevent evaluating the parameter at the next level, use the -null option. To use the parameter's setting at the instance level, type:
```
   db2set parameter= -null -i instance-name
```
The -null option allows you to set the value of a parameter globally, but unset the value for a specific instance. For example, you can set DB2COMM to TCPIP at the global level, and if you have four instances on your system, you can set three of the instances to default to the global setting, but use the -null option to unset DB2COMM on the fourth instance.
To evaluate the current session's parameter's value, type:
```
   db2set parameter
```
To evaluate the parameter's value at all levels, type:
```
   db2set parameter -all
```
To view a list of all values defined in the profile registry, type:
```
   db2set -all
```

For more information on the db2set command and remote administering of the DB2 profile registry, refer to the Command Reference.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]