config db2 server and Datastage EE on IBM AIX
Moderators: chulett, rschirm, roy
config db2 server and Datastage EE on IBM AIX
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.
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.
Re: config db2 server and Datastage EE on IBM AIX
Read the installation and administration guides first.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
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.
DSXChange isn't a substitute for documentation or training, it is used as a supplement.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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
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
That doesn't look like a valid export command line at all!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;
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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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..
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..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Completely build LIBPATH before exporting LIBPATH. Only LIBPATH.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
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"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>