How do we set a global registry variable in db2.

I know we can set instance level registry by issuing the below command
eg: db2set DB2COMM=tcpip

I want to set this parameter globally how do we do that?

I tried doing db2set -g DB2COMM=tcpip, it errors out.

could you publish the error - was it executed by instance owner ?

SQL 1042C system error

Exaplanation of this error is as mentioned below. Please check that out. Please also let us know if somthing changed in recent with your db2 setup like new fix pack installetion etc.. what is the dblevel of your installed db2 ?


A system error occurred. Some possible reasons for this error are:

The database manager is not installed correctly or the environment is not set up correctly.
On UNIX-based systems, db2iupdt may need to be run in order to update the DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options, FixPaks, or modification levels.
You might get this message if you are not using the correct DB2 Administration Server password.
The command cannot be processed.

User response
To update the instance to acquire a configuration or access to function run DB2IUPDT <InstName>.
If the error occurred while trying to connect to a database, get a trace (instructions below) and call IBM support.



Thanks
Naval K

I thought you'd been on this forum long enough to figure out that you'd need to start by looking at db2diag.log...

Try using root

"root authority to set variables in the global-level registry" :
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Tried and found working as below

Logged as root. Loaded db2profile. Then it works as db2set -g DB2COMM=TCPIP

Seems that db2inst1 user does not have os privileges neede to change the registry.

Regards