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
xch2005
Participant
Posts: 85 Joined: Fri Apr 29, 2005 3:13 am
Location: India
Post
by xch2005 » Thu Jun 02, 2011 2:08 pm
Hi,
I am trying to load 16 Oracle tables from Sybase in parallel. Randomly some table or other fails in the process due to connectivity issue.
We my sequence job starts all the jobs run in parallel, is this correct way of performing the data load. We are having in this way to have better completion time.
It is basically a direct load and no calculations are done.
Is there any other alternate way to acheive this?
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Jun 02, 2011 2:09 pm
Define "connectivity issue".
-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 » Thu Jun 02, 2011 4:53 pm
Make sure your Oracle DBA has configured a sufficient number of listeners.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Jun 02, 2011 7:53 pm
There's typically just one but the limit on the max number of and/or rate of connections could be too low. Depends on how this "connectivity issue" manifests itself.
-craig
"You can never have too many knives" -- Logan Nine Fingers
synsog
Premium Member
Posts: 232 Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune
Post
by synsog » Fri Jun 03, 2011 10:59 am
The error message which I got was,
Fatal: ct_fetch failed or canceled during fetch to Sybase table which is the source stage
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Jun 03, 2011 4:00 pm
And this is related to the problem reported by xch2005 how?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
xch2005
Participant
Posts: 85 Joined: Fri Apr 29, 2005 3:13 am
Location: India
Post
by xch2005 » Tue Jun 07, 2011 10:14 am
Now split up the jobs into batches and executing them from sequence