DSXchange

I have db2 server,client, datastage EE installed on the same IBM AIX server. I have installed DS Client in windows xp pc.

What are the configuration that i need to make in dsenv file and configure Environmental variable in order to make connectivity.

Pls i need some example or detailed explanation which will help us to implement.

Read the installation and administration guides first.

To expand on what sud has mentioned : read the manual, try what it suggests and then, if you have problems, report what you tried and what went wrong. You will get a quick and hopefully correct answer in that case.

DSXChange isn't a substitute for documentation or training, it is used as a supplement.

i have configured db2 aswell as datastage. Now when i run the job im getting the following error "main_program: Fatal Error: Fatal: Shared library (dsdb2.so) failed to load: errno = (2), system message = (No such file or directory)

It would seem that your environment isn't set up completely and the library is missing.
1. I'm on V8 so my libraries are in different positions, but you can use "cd $DSHOME\.." and "find . -name dsdb2.so" to get the directory
2. Ensure that this directory is part of the LIBPATH environment variable.

thanks Arndw,

I checked and found dsdb2.so file in /Datastage/DSEngine/lib

I have configured the libpath in dsenv file as follows

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH/bin:$LIBPATH:$INSTHOME/sqllib/lib;

but still im getting the same error

Where are the other three variables for DB2, db2instance, db2dir, and
db2clintpath?

DB2DIR=/usr/opt/db2_08_01;export DB2DIR
DB2INSTANCE=db2inst1;export DB2INSTANCE

i dont know about db2clintpath, what path i have to set?

2ksaint wrote:LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH/bin:$LIBPATH:$INSTHOME/sqllib/lib;

That doesn't look like a valid export command line at all!

Arndw,

if you see in the libpath i have given two times the $DSHOME/java/jre/bin.
which was given incorrect while posting i typed twice.


Actualy lib path

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic: export LIBPATH/bin:$LIBPATH:$INSTHOME/sqllib/lib;

Do you have any idea regarding this issue..

I also dont know about db2clintpath that was mentioned by lstsaur..

Arnd's point was that the export command should be followed only by the environment variable name.

Completely build LIBPATH before exporting LIBPATH. Only LIBPATH.

thanks ray,

I changed the libpath to till classic: and then i have just given export LIBPATH

but still im getting the same error

Hi guys,

Do anyone have any suggestion regarding my issue. if anyone have the dsenv file with db2 and ds server configuration, please post it so that i can refer to that... (If possible)

Thanks in advance

Following are the DB2 entries of the dsenv in my Linux environment:

INSTHOME=/home/db2inst1;export INSTHOME
DB2INSTANCE=db2inst1;export DB2INSTANCE
DB2DIR=/opt/IBM/db2/V9.1;export DB2DIR
DB2CLIINIPATH=$DSHOME;export DB2CLIINIPATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib; export LD_LIBRARY_PATH

When you run a job, the complete environment is put into one of the first log entries. Run your job and check to make 100% sure that your LIBPATH at runtime contains "/Datastage/DSEngine/lib"