It is a feature of DB2 using which you can change various
environment variables which can have effect on server even outside the instance
and database configuration settings. It is used to alter operations of your DB2
data server.
Main advantage of it is that after doing any changes in
environment variables you need not to reboot your server for changes to take
effect, which was required earlier.
Some parameters which can be changed using it are:
DB2_SKIPINSERTED, DB2_MDC_ROLLOUT, DB2COMM.
It is divided into 4 regions:
1. DB2
Instance Level Profile Registry:
Majority
of environment variables are placed here. Variables related to particular
instance are kept in this registry. Values defined here override global level
settings.
2. DB2 Global
Level Profile Registry:
If
a variable is not set for a particular instance, this registry will be used.
3. DB2
Instance Node Level Profile Registry:
Variables
related to a partition in a partitioned-database environment are set here.
4. DB2
Instance Profile Registry:
It contains
list of all instance names recognized by system. You can see them using
DB2ILIST.
Comments
Post a Comment