DSXchange

Tell me more about dscmdexport and import. Were running 5.1. Thanks, Myles -----Original Message----- From: Riccardo Tani [mailto:riccardo.tani@datamat.it] Sent: Tuesday, May 14, 2002 9:08 AM To: datastage-users@oliver.com Subject: Re: Automatic export You are right if your export starts when some j...

You are right if your export starts when some jobs are locked, but you know that this is not the right way!! Moreover, on DS5.x, there are also 2 new interesting utilities that can be run unattended (dscmdexport.exe and dscmdimport.exe). Regards, Riccardo ----- Original Message ----- From: "Myles Si...

You still run the chance of being prompted for something. Especially with export if a component is locked by someone using/modifying it. If someone has some insight on how to get around this, API?, it would be greatly appreciated. Also, your export log may not be want you think using the .exe. Regar...

Hi Christian, you can use dsexport.exe/dsimport.exe. This are client utilities. Take a look to "Datastage Manager Guide" manual. Hope this will help you Regards, Riccardo ----- Original Message ----- From: "Pelletier, Christian" To: Sent: Monday, May 13, 2002 10:52 PM Subject: Automatic export > Hi ...

This might be completely off base, but is it possible that you have system backups trying to backup the DataStage project directory while the jobs are running? This situation can result in a wide range of reported problems, not dissimilar to yours. -----Original Message----- From: Huygelen, Luc [mai...

Make sure that one and only one user compiles, executes, and schedules jobs. -----Original Message----- From: Huygelen, Luc [mailto:luc.huygelen@eds.com] Sent: Tuesday, May 14, 2002 4:34 AM To: datastage-users@oliver.com Subject: Job scheduling/execution problems We have a number of master jobs, the...

Just a thought on this since Ive had something similar happen to me. 1. double check that the job you are referencing has been compiled 2. I would move this line right after the Job Attach. If NOT(hJob1) Then Call DSLogFatal("Job Failed: " :jobname ,JobControl") Abort End 3. If you reattach after re...

We have a number of master jobs, these are datastage jobs scheduled in Datastage which execute a number of ETL Datastage jobs. Ive included the main code of these master jobs. (Datastage runs on an E10K with 2 datastage projects: Development and Production, we run datastage v4.1) Our batch normally ...

Dear Kalus, Thank for your answer. I agree with all your considerations. I want only be sure that Im obtaining the best by my OCI8 stages. Best Regards, Marzio Rotondo ----- Original Message ----- From: To: Sent: Tuesday, May 14, 2002 10:36 AM Subject: RE: Datastage performances > Marzio, > > first:...

Marzio, first: your scenario for performance evaluation is not what you would actually use an ETL-tool for. For just reading and then writing from one ORA-table to another is what you would do best with a SQL script! Using an ETL-tools means you will do lot of (complicate) tranformation, resizing, i...

Dear all, Im trying to evaluate the performances of DataStage in our applications. The job Ive built is a simple oci8 --> transformer --> oci8 stages. I read an Oracle table with 2156338 rows and a phisical segment dimension of 665 Mb. The transformer stage simply add the @outrownum to the output an...

Hi everyone!

Does someone have ever tried to write a process to export DataStage components on a scheduled manner? I mean, is there a way to do an export on a prescheduled basis, without any manual intervention? Is there any DS functions to do that?

Thanks!

Christian

Thanks, Ray and John, for your responses to my post. To your questions: 1. We are creating hashed files in Job Control like this (unchanged from our working v4.1 incarnation of the job): * Empty and, if needed, create hashed file OUreject to hold accumulated rejected records from this job OPEN ,OUre...

This is a topic for an orphaned message.

Hi Robert have you tried to export jobs in XML format checking "Include reference to style sheet..." option??? I think you will find it very interesting. Regards, Riccardo ----- Original Message ----- From: "DataStage Developer" To: Sent: Monday, March 11, 2002 12:45 PM Subject: Re: How to find info...