config db2 server and Datastage EE on IBM AIX

[2ksaint]

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.

[sud]

Read the installation and administration guides first.

[ArndW]

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.

[2ksaint]

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)

[ArndW]

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.

[2ksaint]

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

[lstsaur]

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

[2ksaint]

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

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

[ArndW]

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!

Code: Select all

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

[2ksaint]

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..

[ray.wurlod]

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.

[2ksaint]

thanks ray,

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

but still im getting the same error

[2ksaint]

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

[lstsaur]

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

[ArndW]

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"