DSXchange

surprising now as ken said i did ,it read 15000 record per second,
it take only 24 second to read all database table,
so what is solution now i need to apply for this job,it taking more time in real job.
Thanks.

To demonstrate that DataStage is not your problem, put @FALSE in a Transformer stage output constraint immediately after the OCI stage. I'm fairly sure your query is not sending rows very quickly to DataStage. Also, make sure you're looking at the database server and DataStage server cpu utilizatio...

I have like 2,000,000 records,right now i used user define query to read table,
which is join 4 different table and also it is reading 150 records per second.
Thanks.

Hi all,
Is there any positive output for reading oracle database table from OCI9I stage in server job by changing Array Size and Pre fetch memory settings,
if yes then what should be that?
reply me Thanks.

I reboot My system Now it is working

Thanks

Hello,

After compiling job,when I run job from Designer it is not running and in Director status of job remained "compiled" But when I am running from Director then it is running fine.

What can be problem. This is 1st time I came across.

I done as you told,
Now its working fine.
Thanks all.

I just want to know if i dont use Link Collector,then Hash file is going to be corrupted or not.?
because my other team member got this kind of problem in past that why they recomonde to do so.
so tell me about that,
Thanks.

DSguru,
but single Hash file reads "Round-Robin"(sequentially) or it just append all hash file,if it append all hash file then ideally it taking more time,because it wait for all file to read.
so answer me,actually my problem was solve.
Thanks.

swades wrote:

DSguru2B wrote:What happens when you write to the same hashed file from these 18 hashed files without the link collectory?

how could i do this job?

i mean with out collector stage how can i merge 18 files.

DSguru2B wrote:What happens when you write to the same hashed file from these 18 hashed files without the link collectory?

how could i do this job?

Hi, I did not try for that, actually this job is design by another person, and i cannt change in it,so here the design, 18 hash files----> link collector---->a single hash file. my job ,every time freeze at this point and its shows blue link and there is not a single warning or fatal error. so reply...

In out job 18 hash file we merge to a single hash file ,so i think problem with hash file reading or link collector stage is slow,
we collect through "Round Robin" type.
so help me Thanks.

I reset and run this job 3 times,
Even i did not get any warning or fatal errors,
still my job stops at this point.
i dont have any other information.
Thanks.

Hi All,
I am running server job and my job is freezing at certain point,
can somebody tell me why this happen,
i got this message in log file,

CopyOfJ_NTWX_FACT_ORDER_DETAILS..LC_MERGE_ROWS: DSD.StageRun Active stage starting, tracemode = 0.

Thnaks.