Page 1 of 1

Configurating DB2 Connectivity

Posted: Tue Mar 02, 2010 6:57 am
by J.Calvo
Hello Colleagues,

I have tom migrate all the information present in a Datastage 7.0 server
to a Datastage 7.5 Server, running on windows. I have configured the server, and some connections, but I need to config an DB2 connection to access with DB2/UDB Stage, non ODBC, I have installed the clint succesfully, but i have to config any configuration file or system variable because the stage runs fails.

Could you help me?

Thx!

Posted: Tue Mar 02, 2010 8:19 am
by chulett
Have you gone through the documentation, the configuration steps there? For 7.x thatshould be in something like the dsdb2.pdf manual.

Re: Configurating DB2 Connectivity

Posted: Wed Mar 03, 2010 12:02 am
by MT
Hi,

if you hvae the DB2 client you have to catalog the server and the database in oder to be able to establish a connection:
db2 catalog tcpip node xxx remote <servername> server <port>
db2 catalog database <dbalias> at node xxx

Once done that you can test ist via a connect command from the DB2 command window:
db2 connect to <dbalias> user <userid>

If you successfully established the connection the DB2 stage should work as well.
J.Calvo wrote:Hello Colleagues,

I have tom migrate all the information present in a Datastage 7.0 server
to a Datastage 7.5 Server, running on windows. I have configured the server, and some connections, but I need to config an DB2 connection to access with DB2/UDB Stage, non ODBC, I have installed the clint succesfully, but i have to config any configuration file or system variable because the stage runs fails.

Could you help me?

Thx!
globomike

OK

Posted: Thu Mar 04, 2010 7:30 am
by J.Calvo
Thanks

OK

Posted: Thu Mar 04, 2010 7:32 am
by J.Calvo
Thanks