On Sep 4, 1:29*pm, peter sands <peter_sa...@techemail.comwrote:
Hello,
Just upgraded to 9.1 fp3 from 8.2 *(linux)
Noticed the db2set variable: db2instdef
Can some expalin what this variable name holds.
Does this replace the other db2set variable : db2instance
thanks
Pete.
From the DB2 v9 Information Center:
Setting the current instance environment variables
Procedure
When you run commands to start or stop an instance's database manager,
DB2(R) applies the command to the current instance. DB2 determines the
current instance as follows:
If the DB2INSTANCE environment variable is set for the current
session, its value is the current instance. To set the DB2INSTANCE
environment variable, enter:
set db2instance=<new_instance_name>
If the DB2INSTANCE environment variable is not set for the current
session, the DB2 database manager uses the setting for the DB2INSTANCE
environment variable from the system environment variables. On
Windows(R), system environment variables are set in the System
Environment registry.
If the DB2INSTANCE environment variable is not set at all, the DB2
database manager uses the registry variable, DB2INSTDEF.
To set the DB2INSTDEF registry variable at the global level of the
registry, enter:
db2set db2instdef=<new_instance_name-g
To determine which instance applies to the current session, enter:
db2 get instance