Quick Beginnings for DB2 Extended Enterprise Edition for UNIX
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
- 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,
db2set parameter=value -i instance_name node_number
- To set a parameter for the current instance, enter:
- 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
- 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.
- 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
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:
- 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:
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 ]