Hi,

I have two similar db2 v8 instances, instance owner shell is csh. One of these systems has some problems - and I noticed that environments for db2 processes are different. I took db2agent process as an example and printed environment using AIX command: And yes the output was different - one instance had additional variables.

According to IBM if I want to set unsupported environment variable:
So I included missing variables into usercshrc, like:
After that I restarted problematic instance and checked again using "ps eww pid" - there was no aditional variables I included in usercshrc !

What am I doing wrong ? How to add additional environment variables to db2 processes(db2agent for example) ?

thanks
Vilius

try to source your .profile (.login), restart the instance and then check ps eww output

Hi,

.login .profile .cshrc sqllib/usercshrc sqllib/userprofile - all these files are the same(according to instance).

One instance db2 processes have enviroment vars contained into usercshrc, while other instance processes don't - even usercshrc contains the same vars.
Maybe one instance is configured NOT to read usercshrc somehow ?

Vilius

.login should have a call to sqllib/db2profile and sqllib/db2profile should have a call to sqllib/usercshrc. Execute "env" to check if the variable is set.


Example:

env | grep -i db2test
DB2TEST=132


ps eww 876590
PID TTY STAT TIME COMMAND
876590 - A 0:00 db2sysc DB2_SKIP_TRACE=1 DB2TEST=132 HOME=...