Connecting Databases on two different db2 instances
Posted: Thu Jan 10, 2008 8:44 am
Can we connect databases in two different db2 instances in a single job?
Description:
We have two databases which are configured to different instances. Say Database1 on Instance1 and Database2 on Instance2.
We want to build a job which will read TableA from Database1 (Instance1) and wants to populate values to TableA in Databse2 (Instance2). I am using DB2_UDB_Enterprise stage to access these tables. I have coded proper Instance names in input and output DB2 stages. My job is getting aborted by giving following error message.
sqlstate = SQL1013N The database alias name or database name "Databse2" could not be
found. SQLSTATE=42705
Also, please note that /opt/Ascential/Ascential/DataStage/DSEngine/dsenv script contains Instance1 added to it. I think we cannot add two instances there.
Please let me know whether it is possible to connect multiple instances?
Note: We are using Datastage version 7.1 and DB2 version 8.
Description:
We have two databases which are configured to different instances. Say Database1 on Instance1 and Database2 on Instance2.
We want to build a job which will read TableA from Database1 (Instance1) and wants to populate values to TableA in Databse2 (Instance2). I am using DB2_UDB_Enterprise stage to access these tables. I have coded proper Instance names in input and output DB2 stages. My job is getting aborted by giving following error message.
sqlstate = SQL1013N The database alias name or database name "Databse2" could not be
found. SQLSTATE=42705
Also, please note that /opt/Ascential/Ascential/DataStage/DSEngine/dsenv script contains Instance1 added to it. I think we cannot add two instances there.
Please let me know whether it is possible to connect multiple instances?
Note: We are using Datastage version 7.1 and DB2 version 8.