Setting env variable in DB2 env

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shaan.shaan@gmail.com - 06 Jul 2006 10:37 GMT

Hi
I am trying to set an env. variable by exporting in unix environment on
DB2.
I am using export var_name=ON, but it is not taking the value of the
var_name.
This thing is working fine when I am doing it on a simple c++ program
and retieving it by using getenv() function.
Can anyone help me in getting the solution how to set an env variable
in db2
zeeshan

Reply to this Message

Gert van der Kooij - 06 Jul 2006 10:49 GMT

> Hi
> I am trying to set an env. variable by exporting in unix environment on
[quoted text clipped - 6 lines]
> in db2
> zeeshan

Check the description of the DB2ENVLIST variable at
http://tinyurl.com/jah5m

Reply to this Message

shaan.shaan@gmail.com - 06 Jul 2006 11:36 GMT

Hi thanks for the reply but I am not able to access this link.
Can you help me?

> > Hi
> > I am trying to set an env. variable by exporting in unix environment on
[quoted text clipped - 9 lines]
> Check the description of the DB2ENVLIST variable at
> http://tinyurl.com/jah5m

Reply to this Message

Serge Rielau - 06 Jul 2006 12:18 GMT

>> Hi
>> I am trying to set an env. variable by exporting in unix environment on
[quoted text clipped - 9 lines]
> Check the description of the DB2ENVLIST variable at
> http://tinyurl.com/jah5m

Information Center: Reference->Registry and environment
variables->System environent

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

shaan.shaan@gmail.com - 06 Jul 2006 16:04 GMT

hi please tell me exactly what to do for setting the env. variable .
I am not able to understand in the document.
zeeshan

> >> Hi
> >> I am trying to set an env. variable by exporting in unix environment on
[quoted text clipped - 21 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Darin McBride - 06 Jul 2006 16:32 GMT

> hi please tell me exactly what to do for setting the env. variable .
> I am not able to understand in the document.

This variable lists specific variable names for either stored procedures or
user-defined functions. By default, the db2start command filters out all
user environment variables except those prefixed with DB2 or db2. If
specific environment variables must be passed to either stored procedures
or user-defined functions, you can list the variable names in the
DB2ENVLIST environment variable. Separate each variable name by one or more
spaces.

What exactly have you tried after reading the document?

$ db2set DB2ENVLIST=var_name
$ export var_name=ON
$ db2start

Reply to this Message

shaan.shaan@gmail.com - 06 Jul 2006 17:14 GMT

Hi Darin ,
Thanks for the info.
Do I have to give the below mentioned command on the command prompt
directly before running the application?
Best Regards,
Zeeshan

> > hi please tell me exactly what to do for setting the env. variable .
> > I am not able to understand in the document.
[quoted text clipped - 12 lines]
> $ export var_name=ON
> $ db2start

Reply to this Message