Page 1 of 1

Connecting two different db2 databases

Posted: Fri Aug 06, 2010 1:17 am
by rajakannan
Due to look up our server job is getting long time to run.The target is in one db2 database and source is in other db2 database.The source is selecting some columns and target is deleting the same columns if exist....

Now i decided to remove the look up...if look up is not there datastage is creating logs for each records...SO i decided to change the code in source side .......

Plz help me in this........ :oops:

Posted: Fri Aug 06, 2010 1:24 am
by ArndW
What sort of "logs" are created with the lookup removed from your job? Was the lookup to one of the databases? What is your actual question or problem?

p.s. The "FAQ" discussion is for frequently asked questions.

Posted: Fri Aug 06, 2010 1:33 am
by rajakannan
it is creating warning if the record is not in target...we are using unix environment so the log size is increasing....

i decided to do any code change to avoid look ups in this jobs.. i cant able to join the target and source database as both are different....

Posted: Fri Aug 06, 2010 1:41 am
by ArndW
I am a bit confused. Could you please post the actual warning message?