Quick Beginnings for DB2 Extended Enterprise Edition for UNIX

Controlling the DB2 Profile Registry

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

DB2 node-level profile:: This profile is only used with DB2 Universal Database Extended Edition. It contains node-level variable settings and overrides. Values defined in this level will override their settings in the instance and global levels.
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 machine global variable settings. Any variable not defined at the node or instance levels will be evaluated at this level. (In DB2 Extended Enterprise Edition, one global-level profile exists at each machine.)

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

To set a parameter for a specific DB2 Extended Enterprise Edition node, enter:
```
   db2set parameter=value -i instance_name node_number      
```
To set a parameter for the current instance, enter:
```
   db2set parameter=value
```
To set a parameter's value for a specific instance, enter:
```
   db2set parameter=value -i instance_name
```
To set a parameter at the global profile level, enter:
```
   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; for example, 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, enter:
```
   db2set parameter= -i instance-name node-number
```
To delete the parameter's setting at the instance level and prevent use of the variable at the global level, enter:
```
   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 view the current session's parameter's value, enter:
```
   db2set parameter
```
To view the parameter's value at all levels, enter:
```
   db2set parameter -all
```
To view a list of all values defined in the profile registry, enter:
```
   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 ]