DSXchange

Zabeerulla You need to understand TCL commands. All the SQL you run against the repository tables are TCL commands. You could also probably get what you want with MetaStage or Reporting Assistant. Both of these extract information from the repository tables like DS_JOBS and DS_JOBOBJECTS to their ow...

Visual Source Safe.

I agree with Ray but this has been posted already.

Does this report the table name or stage names and link names?

Very nice. I think this well done. I like his Texan. Very easy to understand.

http://www.dsxchange.com/viewtopic.php?t=96760 shows how to get sequential files. Getting the tablenames is more complicated depending on the stage types. The plugins are the hardest to get out of the repository. User defined SQL makes this even harder.

What stage types are you using? Tell me what you are using and maybe I have the SQL.

Nothing is truly simple on a mainframe. Is it Ray?

CoSort is integrated with DataStage. It has its own plugin. Both are super fast in sorting flat files especially fixed width. They can aggregate as well. The setup on them is kind of like building a file to describe the metadata for a bulk load for Oracle or Redbrick. They are ugly little script fil...

It is my understanding that USS is to mainframes like MKS Toolkit is to Windows. It is a UNIX emulator that runs under a different OS.

Should post a new version of EtlStats soon. I cleaned up a lot of stuff.

Maybe all you want to know is which sequences ran long. /* ----------------------------------------------------------------- SeqRunningLong2.sql Decription: Returns list of Jobs. Written by: Kim Duke Notes: This shows the last run of the a job compared to the average plus one standard deviation away...

The problem is I only want jobs which ran today. I only want jobs which ran for 5 minutes or more. What difference does it make on small jobs. I want to list the important jobs only. I also want jobs which are running slower based on rows per second. Either could be a problem. /* -------------------...

This is SQL Server syntax. If you figure this out for Oracle or another database then please post it. getdate() is the current date. datepart(DW, getdate()) will get the day of the week for today. stddev() is the standard deviation for the current avg(). Most numbers should be within one standard de...

Your ETL took longer today than normal. Your boss asks why. Was it more data being processed, network traffic or some other issue. How do you find out what it was? We had this issue this week. This is how I solved it. What is the average number of rows for each job? This varies by weekday. So what i...

I would delete this project and start over with a backup.