Page 1 of 1

How to catlog DB2 database with Datastage

Posted: Wed Sep 13, 2006 9:10 am
by somu_june
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.

Posted: Wed Sep 13, 2006 10:39 am
by lstsaur
Somaraju,
You need to install the DB2 Connect on the Unix side. Then from the db2 command prompt you issue the following:
db2 => catalog tcpip node r2e6 remote r2e6.mkm.com server 6534
db2 => catalog db SKR2 at node r2e6

Posted: Wed Sep 13, 2006 10:50 am
by somu_june
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

Posted: Wed Sep 13, 2006 2:56 pm
by lstsaur
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

Re: How to catlog DB2 database with Datastage

Posted: Mon Jan 07, 2008 12:20 am
by kiran259
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.
Hi,
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??