Hi,
I am using Oracle Enterprise stage in Datastage PX v7.5.1. The stage showing execution mode as sequential only while reading from the oracle 10g table. How can I make it to parallel as the execution method is set to sequential by default and not allowing me to change to parallel as it is disabled.
Thanks in Advance.
Tushar
Oracle Enterprise stage showing execution mode as sequential
Moderators: chulett, rschirm, roy
-
tusharzade
- Participant
- Posts: 13
- Joined: Wed Dec 15, 2004 2:19 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And it is documented as behaving thus for SELECT.
If you set the Partition Table property then its execution mode may be able to be set to parallel but otherwise you're limited to sequential. This is because of how Oracle delivers its results; they are stored in a temporary table (whether in memory or on disk) and these results are streamed to the requesting client.
If you set the Partition Table property then its execution mode may be able to be set to parallel but otherwise you're limited to sequential. This is because of how Oracle delivers its results; they are stored in a temporary table (whether in memory or on disk) and these results are streamed to the requesting client.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.