Hi,
I want to connect to DB2 remotely . There is already DB2 client 32 bit installed in same server as DS . Where do I need to provide Catalog commands in Datastage Server DSHOME directory or in DB2 Client in my local meachine the commands are
db2 catalog tcpip node r2e6 remote r2e6.mkm.com server 6534
db2 catalog db SKR2 at node r2e6
db2 terminate
Thanks,
Somaraju.
How to catlog DB2 database with Datastage
Moderators: chulett, rschirm, roy
Hi,
You said that I need to install the DB2 Connect on the Unix side . That means I need to install the DB2 Connect on my Datastage Unix server.
Then what about the
#DB2INSTANCE is the name of the DB2 client where the databases are cataloged
DB2INSTANCE=db2inst1; export $DB2INSTANCE
What I need to provide for DB2INSTANCE value .
Thanks,
Somaraju
You said that I need to install the DB2 Connect on the Unix side . That means I need to install the DB2 Connect on my Datastage Unix server.
Then what about the
#DB2INSTANCE is the name of the DB2 client where the databases are cataloged
DB2INSTANCE=db2inst1; export $DB2INSTANCE
What I need to provide for DB2INSTANCE value .
Thanks,
Somaraju
somaraju
Hi,
Yes, install the DB2 Connect on your DS server (Unix) side. If a DB2 instance is not created during the DB2 Connect installation, then you need to go the instance directory to issue the following command:
db2icrt -s client db2inst1
After that then define the following variables in your DS dsenv file:
INSTHOME=/home/db2inst1;export INSTHOME
DB2INSTANCE=db2inst1;export DB2INSTANCE
DB2DIR=/opt/IBM/db2/V8.1;export DB2DIR
DB2CLIINIPATH=/home/dsadm/Ascential/DataStage/DSEngine;export DB2CLIINIPATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib; export LD_LIBRARY_PATH
Yes, install the DB2 Connect on your DS server (Unix) side. If a DB2 instance is not created during the DB2 Connect installation, then you need to go the instance directory to issue the following command:
db2icrt -s client db2inst1
After that then define the following variables in your DS dsenv file:
INSTHOME=/home/db2inst1;export INSTHOME
DB2INSTANCE=db2inst1;export DB2INSTANCE
DB2DIR=/opt/IBM/db2/V8.1;export DB2DIR
DB2CLIINIPATH=/home/dsadm/Ascential/DataStage/DSEngine;export DB2CLIINIPATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib; export LD_LIBRARY_PATH
Re: How to catlog DB2 database with Datastage
Hi,somu_june wrote:Hi,
I want to connect to DB2 remotely . There is already DB2 client 32 bit installed in same server as DS . Where do I need to provide Catalog commands in Datastage Server DSHOME directory or in DB2 Client in my local meachine the commands are
db2 catalog tcpip node r2e6 remote r2e6.mkm.com server 6534
db2 catalog db SKR2 at node r2e6
db2 terminate
Thanks,
Somaraju.
I have a question reg this cataloging.You have provided a solution to catalog DB2 and DS which are in the same server.For instance, in an environment where DS is kept on one server and DB2(DPF )is on another server,How do I catalog these two servers?To be clear:
DS-IP addr1
DB2 -IP addr2
We have installed DB2 in DS server.But we need to catalog DS and DB2 database present in another server.
Could you provide us the solution??