DSXchange

The solution at Bellsouth was a political one and not an ETL one. Our team was still a good team.

Is there any way to treat the repository as a source in a DS job and pump the data right into DB2? Yes. There are jobs in EtlStats which do this. I had to use UV stages instead of hash file stages. To get row counts on every job then all you need is to do is run the job DSJobReportDbDriver and use ...

Let me know if anyone gets this to work. It is so complex on some of this stuff I was afraid to release it. The results are lots better than I expected though. The web pages with the log files are cool. I like the row counts too. I think I need to add the date to the attachments so when you save the...

I have never used those. I have no idea where they are stored. If someone knows then post it. Maybe we can hack a solution.

If I posted all of those then anyone could command the same level of fees that I do. I seriously doubt that. We would just know 47 things Ray knows. How many posts do you have now and how many do you have left in you? You do not need to post them. You have given us enough for one lifetime but pleas...

You cannot post #47 without postig the other 46 standards.

I found a bug in the output from dsjob -report XML. If a job passes midnight then it does not calculate ElapsedSecs or ElapsedTime both are zero. I fixed this by calculating it from StartDateTime and EndDateTime. I will post my fix this weekend or next week because I am traveling this weekend. I als...

Here is the SQL: SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'OUTER',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO ...

If you have a limited number of stage types then you could also do it from DS_JOBOBJECTS. I think it would be easier to hack. If they are all OCI or sequential stages then I think this maybe reasonable amount of hacking. I think RT_BP is harder to figure out. List the stage types and maybe we can he...

I added a job to monitor our main sequence and all children sequences. It will email the logs of the failed jobs. I plan on making it page the developer soon. I think this is cool. It requires EtlStats.zip above. * ------------------------------------------------------------ * MonitorSeq * ---------...

I posted a routine and so has Ken Bland which will copy parameters. These are hacks into how DataStage stores this information so use at your own risk. Do a search. If you cannot find them then let me know or Ken. I think these are fairly safe. The parameters are stored in the ROOT record of DS_JOBO...

Nobody is going to tell you but you could probably delete this and recreate it. The VOC entry needs to the same as it is now. I think it has a shared DICT file. So unless you know a lot about Universe then this is not a good solution. You could also copy the 2 files in the directory from another RT_...

Ray

I know you are correct but he said user source code. So I assumed he meant routines and batch jobs. He also said he wanted the SQL. Some this could be retrieved in Reporting Assistant. Hopefully my assumptions are correct.

You can download JobReport.dsx from ADN. If you want it for all jobs and all routines then you need to download KgdGenHtml.zip. These generate html pages one per job and one per routine. JobReport.dsx generates the html for jobs. I wrote the one for routines. I wrote the code to run these for more t...

You could be timing out as well. Some security setups have a limit on how long you can stay connected.

Is is easier to write to a sequential file and execute a script to ftp the file. I think it is at least more stable.