Allowing multiple instances when it is not necessary

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
gsherry1
Charter Member
Charter Member
Posts: 173
Joined: Fri Jun 17, 2005 8:31 am
Location: Canada

Allowing multiple instances when it is not necessary

Post by gsherry1 »

Hello Forum

Why aren't all jobs enabled to allow multiple instances by default, and what are the drawbacks of enabling the multi instance capability when it is not required.

Thanks,

Greg
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Good point. There is not much down side. It complicates the Director listings and that is about it. I think restartability is a little more complicated but is not an issue.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't know... multi-instance jobs typically have to be designed with that capability in mind. Checking that by default allows you to run the job as a multi-instance job when that may not be appropriate.

To me it kind of falls into the same category as including job parameters that nothing in the job uses. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Ultimately the reason is that multi-instance capability did not exist in version 1.0, and the default has never been changed.

My personal view is that enabling multi-instance unnecessarily introduces an unwanted level of complexity, even if it's only a small level.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

There should be no overhead to the physical job execution. If a job is unnecessarily enabled but never ran as an instance, there is probably no impact whatsoever to performance. There's no extraneous job log messaging, etc.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Just wondering on using multi-instance mode

Post by jdmiceli »

Hello all!

Just because I have not yet gotten to test the usefulness of this feature, is there anything special I have to do in the design process to take advantage of the benefits of multi-instance mode? I guess I'm looking at it from an unload point of view, where I may be unloading a table that has tens of millions of rows and I want to speed up the process.

As always, your expertice is greatly appreciated.

Bestest!
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Not a great deal of value for parallel jobs (this IS the parallel forum) where it's just as easy to throw a configuration file with more nodes into the mix.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply