DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
rajakannan
Participant



Joined: 24 Feb 2010
Posts: 12
Location: chennai
Points: 148

Post Posted: Fri Aug 06, 2010 1:17 am Reply with quote    Back to top    

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........ Embarassed
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Fri Aug 06, 2010 1:24 am Reply with quote    Back to top    

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.

_________________

Image
Rate this response:  
Not yet rated
rajakannan
Participant



Joined: 24 Feb 2010
Posts: 12
Location: chennai
Points: 148

Post Posted: Fri Aug 06, 2010 1:33 am Reply with quote    Back to top    

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....
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Fri Aug 06, 2010 1:41 am Reply with quote    Back to top    

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

_________________

Image
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours