DSXchange

Well done and great answers.

I did not write it. I modified it a little.

I would look at swap space and % of IO on topas. Either will kill your performance.

You also need to know what views changed.

There is a video on my web site on how to install it. I walk you through it.

There is a job with the same name. Run it.

There are 2 sequences included with EtlStats. At the end of each sequence it runs a driver job which calls the get row count job for every job in the sequence. So you do not have to run the get row counts job after each job. This driver job asks for a job name. If you put all in the job parameter th...

I have a routine which is part of EtlStats which can do attachments in both UNIX and DOS on older versions.

It causes problems when you have more than one developer on the box. Starts to corrupt the repository.

It's a problem or is it, Craig? I hope he owns up to it. After all, its his problem.

Please do not double post!!!

You can document a job in Designer. It outputs an html document which is very nice. It has lots more than you asked for here.

I have a routine which generates XML definitions which can be imported into DataStage. It was fairly easy to build. Just export a table in XML format and generate the same format.

DwNav uses Reporting Assistant data. I plan on uses the DataStage repository tables directly for version 8. Reporting Assistant does not extract PX job metadata or sequences. I extracted sequences to Reporting Assistant tables for DwNav. It was too much work to extract PX jobs when it may not work f...

I would use the SQL in:

http://www.dsxchange.com/viewtopic.php? ... =DsSearch1

Follow my link below my sig.