DSXchange

There are some better ones but this will do http://www.dsxchange.com/viewtopic.php? ... ht=Search1

Are there easily offended people on this forum? Craig really, thanks for looking out for me.

Do a search for EtlStats. It is free.

If you do not have write permission to these directories then you will have problems. It fails hard without any error messages. I should have else clauses on my writes but maybe I missed some. The JobReport routine should be there as well. I did not write this so I cannot fix it. There are notes on ...

I give away a shell help file and a vi one. Just some notes I have put together over the years. Follow my link to my tips page.

We do get the parameter values out of a file. We do validate the parameter name against dsjob -lparams Project Job We have a global list of parameter values which can be overridden by a job level parameter file. We have another script which will build these parameter files from the defaults. The sam...

If you know shell scripting then write it yourself. dsjob -lparams Project Job Will get you a list of params. dsjob -paraminfo DwNav ParameterizeDSNs pDSN2Change Will get you parameter information like the prompt and default values for parameter pDSN2Change in job ParameterizeDSNs in project DwNav. ...

I give away a bunch of jobs and routines call EtlStats. Several of the jobs and routines are just to produce this kind of documentation. The results all come out as html pages. These jobs and routines all have GenHtml in the name. Both EtlStats and GenHtml have been discussed before. Do a search.

I would look at some key tables. Count the rows. Try to estimate the row lenght by guessing the average row length. Take the largest table row length times number of rows and make sure you have several times that amount of disk maybe 10 or 20 times. WAG is maybe the best you can do unless you want t...

I usually put the full description in a annotation box on the design. Then it shows up on your documentation.

Ray will sell you a RMM stage along with this great idea.

You have the code. You does not use a style sheet. It generates simple html. Send me an example of what you want and maybe I will change it otherwise you have the code. You can change it yourself.

The JobReport routine was not written by me. IBM would need to give you that code.

Besides why would anyone want to move the whole DSParams file? The values in this file usually change from DEV to TEST to PROD. Examples would be the config files. You might have a 2 node in DEV and a 8 node in TEST and 16 in PROD.

You are going to have to do it at TCL like http://www.dsxchange.com/viewtopic.php? ... ht=JOBTYPE

CATEGORY and JOBTYPE are in DS_JOBS. Use SQL.

chulett wrote:get used to it!

The only guy who can scold you and make you laugh at the same time. Well said all.