Configurating DB2 Connectivity

[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!

[chulett]

Have you gone through the documentation, the configuration steps there? For 7.x thatshould be in something like the dsdb2.pdf manual.

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

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

[J.Calvo]

Thanks

[J.Calvo]

Thanks