rcp doesn't work correctly
Moderators: chulett, rschirm, roy
rcp doesn't work correctly
i have a seq which orderly works 10 parallel jobs from oracle ES to DB2(by ODBC enterprise stage) with runtime column propagation.
it works when 2 or 5 records but the third job has 16000 records and it doesn't work.is this about rcp ? is there anything i have to check for this ?
it works when 2 or 5 records but the third job has 16000 records and it doesn't work.is this about rcp ? is there anything i have to check for this ?
Last edited by sezerman on Thu Jul 30, 2009 3:00 pm, edited 1 time in total.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: rcp doesn't work
Define " doesn't work ".sezerman wrote: it works when 2 or 5 records but the third job has 16000 records and it doesn't work.
You know the next question - define "never". And "finishes" while we're at it. How long did you give it before deciding it was never going to finish? What did the job look like at that point - were rows processing slowly, not at all, was it part way thru when you stopped it or had it processed everything but not completed completed? What do you see?
I'd be surprised if this is related to RCP but there's absolutely no information to make any kind of informed decision so who knows.
I'd be surprised if this is related to RCP but there's absolutely no information to make any kind of informed decision so who knows.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Jobs that write to a database and never finish usually (don't) do so because of database locks or deadlocks.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
sequential works.thanks.but i have another problem now.the other job has a date column.DS gives meta-data for oracle stage 'timestamp' for date columns.what can i do when using rcp for this matter ? the error message : No default type conversion from type "timestamp" to type "date". (source and target both date)
Just as in the first post, this has nothing to do with rcp. You will need to define a transformation (either in a transform or modify stage) where you tell the job how to convert your timestamp to a date.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Your original subject/problem was not related to rcp. Your second (new) topic in this thread was related to rcp and was answered, even though it is better to keep only one topic per thread.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>