Informational Service related question

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
anajitKS
Premium Member
Premium Member
Posts: 28
Joined: Thu Dec 18, 2014 7:57 pm
Location: Kansas City

Informational Service related question

Post by anajitKS »

I have created an Informational service which has got 2 lookup stages using normal lookup (Not Sparse) involved in it. My question is, is it going to load lookup data in the memory with every request the service receives? or is it going to hold on to the old data that it loaded at the time of the first request?
ABHIJIT DUTTA
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is your job "always running" or "start on demand"? Answering that will basically answer your question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Normal lookups are loaded into memory only once when the job starts. If the reference data may change regularly then you could script the service to disable/enable on a schedule in order to force it to restart the job. Of course you would have a small outage during each restart.
Choose a job you love, and you will never have to work a day in your life. - Confucius
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

...or use sparse lookups instead. They are preferred for realtime (always on) Jobs for exactly this reason.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

... unless it is static reference data. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Indeed... unless the database on the other end of your sparse lookup has a lot of outages.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply