DSXchange

What do you mean by

Produce automation: job parameters, environment variables, and, dsjob

Your syntax looks correct. A 99 usually means job is not in a runnable state.

If you are talking about operational data only then we have some killer reports which compare row counts to CPU utilization and disk utilization. As well as number of jobs running and paging information. Very complete information. You may need to go through IBM management and get our management's ap...

We started to but never got to the dashboard. We created the equivalent in a report at a couple of sites. I am not a Cognos or reporting person so I could never finish the task. The canned reports I called "Completeness" was more detailed and good enough for CFOs. There are several posts o...

The SQL in

viewtopic.php?t=99543

Will find any string in a job. Use it and see if you cannot find all the jobs using a specific table.

Most of these are server jobs. You may need to modify them to accurately capture PX information. Some people have done that and I posted their changes. More than willing to do so. The original post was about logs. The log files of failed jobs are automatically emailed to whoever you want at the end ...

USS is a mainframe version of UNIX. It usually coexists with another OS. It has limitations. I never like these virtual OS. Seems like there are always issues especially in performance. If you are testing and need OS for a while to test a product then fine. If this is a production system then why ha...

By the way the sequences included get row counts for all jobs in the sequence at the end of the sequence. So all the jobs are examples of how to use the other jobs. Some reports are automatically sent at the end of these sequences. Audit reports of the row counts just generated can be very useful in...

We get row counts with a job after each job is run. Currently we use a shell script to run all jobs. It runs the get row counts job after each job. All row counts are stored in run time audit tables. The old versions of the jobs and DDL to create the tables are on my tips and tricks page on my sig. ...

I agree with Ray. I do not use it. I have enough to do and read as it is.

Follow the link to my tips and tricks page.

Backslash can be used as a quote character. It sometimes messes up in the middle of a quote. Not sure why or how to stop it. We need a full Wurlod here. It seems to be more consistent in SQL SELECT.

I tried to implement the public domain one. It is based on compiler overflow. It seems to be inconsistent across compilers, versions of OS, versions of DataStage and other critical issues.

There are several posts on this. I could never make it work. It was inconsistent across servers.

Thanks for all the good ideas and posts.