DSXchange

I have several jobs in EtlStats which create this kind of metadata in a target table. Try to run these jobs. You will be amazed on how much good use you can make out of these types of tables. The Reporting Assistant cannot report on sequences or PX jobs. You can create your own metadata this way and...

If you take the previous query then you could create your own metadata. Now create a job and output the above to a table like:

Thanks for all the nice words but please I do not normally answer emails. If you create this dictionary item then you can report or extract the jobs from a sequence. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM ) VALUES ( 'JobActJobName', 'D', '12', 'JobActJobName'...

Welcome Ernie. An IBMer awesome.

I would turn on the automatic clearing of logs after 3 runs instead of days or something like that. That will help. I posted a SQL statement which will delete RT_STATUSnnn records using instance id. Search for this post. I will post the link if you cannot find it. I know Director slows down a lot wh...

I wish they would buy something but no matter. I think every site needs integrated ETL stats. This is important to performance tuning and managing your ETL. Some of the simple metadata is also very powerful to report against. This is just the bare minimum you may need. IBM must agree because a lot m...

Geez, Ray. Everyone needs this job. Pretty useful job.

DSJobReportDbDriver runs DSJobReportDb over and over for evey job in the sequence. You have source code so you can see how I did it.

Parameters are stored in 2 places. I have thought about this too. Lists are stored I think with tabs between each value. I would have to dig into the code to be sure. DS_JOBOBJECTS stores the first set of values. You would have to understand a lot about the DataStage engine to update these values. T...

I got an idea, XCOPY sucks. You found a bug.

If it is not a lot of work then I will post the solution or email back to you.

Thanks Arnd.

Reverse engineering implies replacing this product with another product. Is that what you intend to do?

We use these methods to only better understand our ETL designs. We actually like DataStage and just want to be better DataStage developers.

Post removed per Ray's post below.

I am assuming you are doing straight table copies. Send sample jobs you want to use as a prototype. I should bill you for it but I want to see if it would be a lot of work first. So mail it to Kim_G_Duke@hotmail.com I will let you know how much work is involved. I will post my answer if you like. Se...