default execution mode

Etler21 · Post by **Etler21** » Thu Aug 25, 2011 12:48 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Aug 25, 2011 3:35 pm

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

Etler21 · Post by **Etler21** » Thu Aug 25, 2011 5:01 pm

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 ?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 25, 2011 7:26 pm

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