access same job

kris18 · Post by **kris18** » Tue Dec 12, 2006 8:55 am

HI All,

we have a job design in which all the jobs( we have like 75 main jobs) calls the same subjob(one subjob), it works fine now because we are running it mannually. but once it goes into production does it create problem ? because we will be running them in parallel and some jobs will access the same subjob while it is been used by other.( we did parametirized the path and hash file name so that it takes different name for different job on the fly)

i was trying to analyze this problem and it came to my mind that if we try to open the job that is already opened by other person then we will get a message saying that it is accessed by other person, does the ds behave in the same way in here or it is different for the above problem??

thank you
kris

DSguru2B · Post by **DSguru2B** » Tue Dec 12, 2006 9:02 am

I dont think it will work. You will get an error, something like 'Job is not in the right state'. Thats why you have multi-instance capability in DataStage. To achieve exactly what you want.

chulett · Post by **chulett** » Tue Dec 12, 2006 9:03 am

You will have a problem in Production as a 'normal' job can only be run by any one given controlling process at a time. If one 'main' job has it running, any other that attempt to start it will error.

You'll need to make your job a Multi-Instance job. Search the forum if you're not familiar with that term and read the Help on the subject availble from the Director client.

Also ensure that it is designed to be run by multiple processes at the same time. For example, don't have them all write to one sequential filename or clear the same hashed file. Make sure any objects like that have unique names (typically based on the Invocation ID but can be other parameters) which is easy to accomplish.

It sounds like you've started down that path with your parameters, but it will still need to be a multi-instance job.

kris18 · Post by **kris18** » Tue Dec 12, 2006 9:27 am

Thanks guys your reply,

i will change it accordingly, one more question is that if we have a user defined routine and if we use same routine in different jobs at same time does this effect the performance of the jobs? or it creates a instance and can be accessed by any number of jobs ?

kris

DSguru2B · Post by **DSguru2B** » Tue Dec 12, 2006 10:48 am

Performance depends upon what your actually doing inside the routine and not upon multiple calls by different jobs. And Yes you can call it from different jobs, that would'nt/should'nt be a problem.

us1aslam1us · Post by **us1aslam1us** » Tue Dec 12, 2006 10:49 am

Hi Kris,

There shouldn't be any performance issues. You will be able to use your routine in other jobs without any problem

Sam

kris18 · Post by **kris18** » Tue Dec 12, 2006 1:30 pm

Thanks chulett,DSguru2B,Sam for the quick response

kris

DSguru2B · Post by **DSguru2B** » Tue Dec 12, 2006 1:52 pm

You can mark the post resolved now.

kris18 · Post by **kris18** » Tue Dec 12, 2006 2:26 pm

i tried to do that but it is giving me following error

[/img]

failure: failure : error--1:15070-topic_id=105908&mark=r

chulett · Post by **chulett** » Tue Dec 12, 2006 4:36 pm

Kris, check this post.

kris18 · Post by **kris18** » Wed Dec 13, 2006 9:00 am

thanks chulett

kris