Num of EE stages in a job

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
deepak.hsbc
Participant
Posts: 39
Joined: Sun Apr 15, 2007 11:30 pm

Num of EE stages in a job

Post by deepak.hsbc »

How can i decide the num of db2 EE stage,to be use in a single job.Currently I am using 8 EE stages in a single job but I feel that it may be a performance issue in future because of large I/O connections.

am i right ?? Any thoguhts ??
"Books are as useful to a stupid person as a mirror is useful to a Blind person."
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

"Am I right?" will almost always be answered with "maybe, maybe not".

The essence of your thought processes should revolve around the capacity of your database server to accept connections.

Of course the goal is not always to saturate it just because you can.
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