DB2 Environment Variables

Some variables are DB2INSTANCE, DB2PATH etc. We will see how to manipulate them using some commands.

     

     1.     Set parameter for current instance:

db2set parameter=value

     2.     Set parameter for specific instance:

db2set parameter=value  -I

     3.     Set parameter at global level:

db2set parameter=value  –g

     4.     To view list of all available variables that can be set:

db2set –lr

     5.     To delete a registry variable setting:

db2set parameter=

     6.     To set variable to null:

                       db2set parameter -null