DSXchange

You can fix this when you FTP to Windows from Linux. You can also use UNIX2DOS and DOS2UNIX commands.

I don't think RT_BP is used on PX jobs.

Everything is optional. It is easy to rip this job apart and only use what you want. See if it compiles. If it does and works fine then you are okay. 1)The install.txt does create directories below each project. These are only for where files are stored as defaults within the jobs. 2) Install these ...

You can import it if you create a q-pointer. I usually create DsJobs or RtLog as q-pointers.

The =+=+=+= is a block of code with CrLf in it. It ends with a second =+=+=+=.

You could read RT_LOGnnn files as a UV stage directly.

The driver can figure out all the jobs in a sequence and feed them into job to get row counts one at a time. There is a sequence included as an example on calling the driver job. It also emails row counts as a report.

You are overwelming your server. The jobs are failing for a lack of resources. Like Ray said.

I tried to respond to your personal message and keep getting an error. So this is my responce. By the way I really like the detail at the partition level. It helps in debugging performance.

you can easily modify DSJobReportDb to update any table you like. It is just an example of how to use dsjob -report XML. This job runs this command in the before job routine. Then processes the results to load 3 tables. You can load your table if you want. Do a search there are several posts where p...

I would setup a few records in the ETL_QA_SQL. Run the jobs associated with this and see if you can make it work. If not then post some more questions. I can walk you through it. I think there is a video on my web site which can also wlk you through it. If not then I will create one.

The part of EtlStats Ray is talking about is called QA Completeness. Do a search for it. It is designed to create a measure in the source and compare it to the target. It should report the percentage of the source in the target. So lets say you count customers in source and compare to to rows in the...

All you need is job DSJobReportDb from EtlStats. There is no licensing. It is all free. The reporting is just examples of how I monitored jobs running at one customer.

Usually the operating system cannot keep up with this many processes starting at the same time. You can get more without failures if you sleep in between starts.

Post how you compiled and how you set it up in DataStage. Your routine looks correct. I suspect you set it up wrong or compiled it incorrectly. You need to compile and not link. You should point DataStage to the .o file.

Do a search and maybe post the link you used to set this up.