DSXchange

Whenever I use a DB2 EE stage in a job,I see its default execution mode is sequential and it is also greyed-out so I can't make it parallel.

I thought Db2EE stage read data parallel from Databases but here it seems to be working just opposite.

Anyone knows if this is the nature of EE stage or I am doing something wrong??


Thanks for the help !!

Etler

Only from partitioned tables does this stage read in parallel; you need to set the partition table property in the stage.

great,I did that and put the source table name in that field but it increased my job execution time to 40 min from 27 min.am i doing something wrong ?

Nothing. You've asked what I suspect to be an already heavily-loaded system to do more work.