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
-
Etler21
- Participant
- Posts: 52
- Joined: Mon Mar 08, 2010 5:51 am
Post
by Etler21 »
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
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Only from partitioned tables does this stage read in parallel; you need to set the partition table property in the stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
Etler21
- Participant
- Posts: 52
- Joined: Mon Mar 08, 2010 5:51 am
Post
by Etler21 »
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
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Nothing. You've asked what I suspect to be an already heavily-loaded system to do more work.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.