Connecting two different db2 databases

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajakannan
Participant
Posts: 12
Joined: Wed Feb 24, 2010 7:04 am
Location: chennai

Connecting two different db2 databases

Post 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:
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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.
rajakannan
Participant
Posts: 12
Joined: Wed Feb 24, 2010 7:04 am
Location: chennai

Post 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....
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I am a bit confused. Could you please post the actual warning message?
Post Reply