DSXchange

that is my concern, file can be locked if all open the same time even though file is just read only.

I generally use Hashfile for lookup only but any extract and load with large volumn of data, I use sequential file.

In share container called FinCollectors, has sequential file as an input and a link to output stage. On this share container has 2 parms. 1 is directory name and other is file name. On other 7 jobs, each job use share container FinCollectors, a link to transform and update/insert to target oracle da...

Hi Craig, You were mentioned 'Think of it as an 'include' file for DataStage, a snippet of code that gets compiled into the job'. My thinking is, if all 7 jobs are running and all open same file at the same time, does it possible hit the limit number of file open or may be file get locked or somethi...

Thank you for all your feedbacks.

I can not duplicated error again. As I mentioned earlier, it doesn't happen often. The previous error has been purged. I will continue post once I get that error again.

thanks again.

I created a share container. In this share container has input file as sequential file and output stage, that's all. I have 7 etl jobs, all 7 jobs use this share container. all 7 jobs are scheduled to run at the same time. Jobs ran successful most of the time and some time it failed with RT_STATUSnn...

Hello Kduke,

Now I was able to imported job MonitorSeq into DS. How and what sequent am I going run this job along with specific job?

thanks,

Yen

Hello Kduke, Autranumdane and ArndW - Thank you so much for such a quick response. Kduke - Where do I find job MonitorSeq in EtlStats? I went to your website http://www.duke-consulting.com/KimD/DataStage_Tips.htm, I clicked etlstat.zip, it said page can not be found. I haven't experienced any DS rou...

Hi,

does any one have job or routine or shell script that is automatic send email if job hung?

thanks in advance.

Yen

Hi Ray Wurlod,

thank you so much for such a quick response. I will send the info to our DataStage Administrator for checking limitation on system. In the mean time, how do we avoid to hit the limit of number of dynamic hash files in the server job?

thanks again.

Yen

Hi,

I have this error but don't know what caused and how to fix it. Any of your help will be appreciated. The error I got is RT_STATUS file, please see error below. Then I reset job, it ran fine. Please advice.

(DSGetJobInfo) Failed to open RT_STATUS767 file.


thanks in advance.

I am so sorry for taking this long. I was out & tried to catch up other projects.

Thank you so much for replying the issue above.
I recreated a job and started from scratch & it works. I think it has to do something with the lookup table and constraint in the transform.


Thank again.