Hello,

Is there any way to set LD_LIBRARY_PATH environment for all users?

I am using
1) Suse Linux 11 Enterprise Server
2) DB2 10.5 Enterprise
3) JDBC drivers

I have setup my environment by using DB2 JDBC by export $CLASSPATH to the right JDBC drivers (db2jcc4.jar) and export LD_LIBRARY_PATH to /home/db2inst1/sqllib/lib. It work fine with the JDBC query which I am able to executed in the same terminal that will connect to DB2 database and return the query result. But when I switch to another users or closed the terminal, the $CLASSPATH and $LD_LIBRARY_PATH has changed. I need to export it again.

Thanks in advance.

Hi,

You can use /etc/profile.local to define the env. variables you need.
For more details see this

Regards

1 members found this post helpful.

Thanks Bathory. It work on my classpath after I exported it in /etc/profile.local but it didnt work on LD_LIBRARY_PATH.

#CLASSPATH and LD_LIBRARY_PATH
export CLASSPATH=/home/db2inst1/sqllib/java/db2jcc4.jar:${CLASSPATH}
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/home/db2inst1/sqllib/lib64

I had cognos installed in the same environment, when I switch over to db2 default user db2inst1,I believe it has been overwrite on LD_LIBRARY_PATH. I still trying to figure out any config where they could have set in cognos or somehow link that to db2.

db2inst1@db2v105:/root/Desktop> $LD_LIBRARY_PATH
bash: /opt/ibm/cognos/c10_64/bin64:/opt/ibm/cognos/c10_64/cgi-bin: No such file

Thank you

it is set, as far as I see. You need to check it by:
echo $LD_LIBRARY_PATH
in this example LD_LIBRARY_PATH is set to /opt/ibm/cognos/c10_64/bin64:/opt/ibm/cognos/c10_64/cgi-bin and you tried to execute it (I mean you tried to execute this string as it was a command) and failed. It is the expected behaviour.