ChannelDB2

Difference of db2dj.ini, export, DB2LIBPATH and DB2ENVLIST

Here's the difference between export and db2dj.ini:
Normally when you an export an environment variable and then start a child process, the child process inherits all the environment variables that were exported to the parent process. See ==>
http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp?top...
When DB2 starts, however, it does NOT copy all the current environment variables into the environment of the DB2 process. (It copies only certain variables.) Since the Federation wrappers need some data source client environment variables, db2dj.ini is introduced. At db2start (if dbm cfg FEDERATION = YES), then the variables listed in db2dj.ini are also copied into the environment of the DB2 process.

The DB2LIBPATH variable is described here =>
http://publib.boulder.ibm.com/infocenter/db2luw/v9//topic/com.ibm.d..., which allows users to list environment variables needed by stored procedures or UDFs.

Views: 330

Tags: DB2, DB2LIBPATH, Federation, configuration, db2dj.ini, export, variable

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service