Hi,
I am reading from Db2 Enterprise stage using "USER_DEFINED" query. The stage is operating in Sequential mode.
Is there any way by which I can make it operate in parallel so that data fetch can be optimized.
Regards,
Sudeep.
Reading From DB2 Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Is this specific to DB2?ray.wurlod wrote:No. SQL is always sequential unless selecting from a partitioned table. I believe (without proof) that user-defined SQL is always sequential. ...
Because I have seen jobs with user-defined SQL run in Parallel mode when a Partition table property is added in case of Oracle Enterprise stage. However, the name of the partition table and the table used in user-defined SQL. I had once given a synonym in the partition table property and the actual name in the user-defined SQL and the job aborted with a lot of ugly warnings.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>