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!
Configurating DB2 Connectivity
Moderators: chulett, rschirm, roy
Configurating DB2 Connectivity
Best Regards,
Jorge Calvo
Jorge Calvo
Re: Configurating DB2 Connectivity
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.
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.
globomikeJ.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!