Quick Beginnings for DB2 Universal Database for UNIX

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 machine global variable settings. Any variable not defined at the node or instance levels will be evaluated at this level.

To modify registry variable values, enter the db2set command.

The syntax of the db2set command is as follows:

To set a parameter, enter:
```
   db2set parameter=value
```
This command will set the parameter that you specify at the default level for that parameter.
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 instance level, enter:
```
   db2set parameter= -g instance
```
To delete a parameter's setting and to restrict its use, if it is defined at a higher profile level, enter:
```
   db2set parameter= -null -i instance
```
This command will delete the setting for the parameter you specify and restrict high level profiles from setting this parameter (in this case, the DB2 global-level profile). However, the parameter you specify could still be set by a lower level profile (in this case, the DB2 node-level profile).
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 the administration 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 ]