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
RK72
Participant
Posts: 154 Joined: Wed Sep 29, 2010 4:10 pm
Post
by RK72 » Tue Sep 20, 2011 2:42 pm
My job extract from database connector stage is saying that Partition reads were not enabled so its running sequentially how to enable it and make it parallel so that it extracts data parallely.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Sep 20, 2011 3:03 pm
Depends. It may not even be possible. Which particular Connector 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.
suse_dk
Participant
Posts: 93 Joined: Thu Aug 11, 2011 6:18 am
Location: Denmark
Post
by suse_dk » Tue Sep 20, 2011 3:03 pm
Set "enable partioned read" to true in the ODBC Connector. Then choose between a modulus or range partitioning method.
_________________
- Susanne
RK72
Participant
Posts: 154 Joined: Wed Sep 29, 2010 4:10 pm
Post
by RK72 » Tue Sep 20, 2011 4:28 pm
Its Oracle connector stage.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Sep 20, 2011 5:53 pm
Your source table must be partitioned in order to enable that, is it?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Sep 20, 2011 7:33 pm
You need to set the Partition Table property.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.