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



Joined: 24 Aug 2006
Posts: 78
Location: india
Points: 1101

Post Posted: Thu Jul 20, 2017 8:57 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

We are working on a RealTime Service which calls the AVI stage.

Are there any better ways to increase the response from QS end.

Internally, how does AVI stage parses the files ? Does it places everytime in memory to scan the files and get the output. the files are currently in NAS mount due to huge space(using world files).

Like In Memory Sql Db options, are there any better ways the files can be placed or AVI stage to be configured that would increase the performance.

Thanks
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2827
Location: USA
Points: 21429

Post Posted: Thu Jul 20, 2017 11:50 am Reply with quote    Back to top    

We used to have that module. We found that on average it did around 70 disk reads per record (for each individual ISD request).

An IBM technote exists with some tips on how to improve the AVI performance. Unfortunately none if the suggestions helped our situation.

I tried putting the reference files on solid state drives and surprisingly that didn't help either. I hope someone else will have some tips that work.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
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