rcp doesn't work correctly

sezerman · Post by **sezerman** » Thu Jul 30, 2009 2:13 pm

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 ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 30, 2009 2:53 pm

sezerman wrote: it works when 2 or 5 records but the third job has 16000 records and it doesn't work.

Define " doesn't work ".

sezerman · Post by **sezerman** » Thu Jul 30, 2009 3:05 pm

never finishes.

chulett · Post by **chulett** » Thu Jul 30, 2009 5:11 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 8:14 pm

For that matter, what do you believe RCP is supposed to do?

ArndW · Post by **ArndW** » Fri Jul 31, 2009 2:00 am

Jobs that write to a database and never finish usually (don't) do so because of database locks or deadlocks.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 31, 2009 2:11 am

Run the target in sequential mode.

sezerman · Post by **sezerman** » Fri Jul 31, 2009 8:10 am

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)

ArndW · Post by **ArndW** » Fri Jul 31, 2009 8:14 am

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.

Sreenivasulu · Post by **Sreenivasulu** » Sun Aug 02, 2009 7:53 am

Use the StringtoDate function. It works fine.
But as ArndW said this is not related to RCP issue

Regards
Sreeni

sezerman · Post by **sezerman** » Mon Aug 03, 2009 1:13 am

[quote="Sreenivasulu"]Use the StringtoDate function. It works fine.
But as ArndW said this is not related to RCP issue

Regards
Sreeni[/quote]

i don't give table definition to ds because i use rcp.while using rcp,can i use a function to transform a column ???. isn't it related with rcp _?

ArndW · Post by **ArndW** » Mon Aug 03, 2009 1:35 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.

DSXchange

rcp doesn't work correctly

rcp doesn't work correctly

Re: rcp doesn't work