DSXchange

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 ??

"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.