In Windows, how you set environment variables depends on whether you are using DB2 Extenders in a non-partitioned environment or in a partitioned database environment (that is, with DB2 Extended Enterprise Edition for Windows).
In Windows, environment variables are stored in the system registry. Variables can be set by opening the Windows control panel and selecting the system icon. From the System Properties dialog, select the Environment tab. There are two windows containing environment variables and their values. The top window displays variables which are in effect for all users. The bottom window displays variables which are in effect for only the current user.
In a Windows partitioned environment, all variables used by DB2 extenders are stored in a private area of the system registry. A program called DMBSET is provided to inspect and change extender variables.
The syntax of the program is:
>>-dmbset--+-------------------------+------------------------->< +-+-variable------------+-+ | '-variable--=--value--' | +-+--g------------+-------+ | '--i--instance--' | +--all--------------------+ +--null-------------------+ +-+--l--+-----------------+ | '--lr-' | '-+--?-+------------------' '--h-'
To query the value of a variable, type dmbset variable_name. For example:
dmbset DB2MMPATH
To set the value of a variable, type: dmbset variable_name=value. For example:
dmbset DB2MMPATH=C:\DMB\SAMPLES
To display the value of all variables for a defined instance, type dmbset -i instance_name. For example:
dmbset -i dmbinst1
To set a value to null, type dmbset variable_name -null. For example:
dmbset DB2MMPATH -null
To display the value of the variables that are used by all instances, type: dmbset -g
To list the names of all variables that are used by DB2 extenders, type: dmbset -lr
To list the names of all instance profiles that are defined in the registry, type: dmbset -l
You have a lot of flexibility in setting environment variables for DB2 extenders in a partitioned database environment. For example, you can specify values for any environment variable, except DB2MMDATAPATH, in any of the following formats:
\\harmony\JimsShr
f:\media
JimsShr\images