DSXchange

Craig, shame on you. I am going to tell Ray you used sequencer.

EtlStats has MB/Sec now.

Ray is correct. There is a DSJobProperties table which has some of it. SELECT DSJobParameters.ProjectName, DSJobParameters.JobName, DSJobParameters.ParamName, DSJobParameters.ParamPrompt, DSJobParameters.ParamType, DSJobParameters.ParamLength, DSJobParameters.ParamScale, DSJobParameters.Description,...

We decided it might be a legal hassle. If you posted IBM always beating Sun even though the servers were not the issue. Maybe they had EMC drives and the disk drives caused these performance gains. How do you compare apples to apples? EtlStats along with hardware profiles could produce good stats. W...

Eric m should give you the fields you need. select DS_JOBS.NAME JobName, ParamNames, ParamDefault from unnest DS_JOBOBJECTS on MvParams, DS_JOBS where DS_JOBOBJECTS.OBJNAME = 'ROOT' and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO order by ParamNames ; Modify this script to meet your needs. You need to cre...

The problem is not in the number of processes per CPU or user. It is that you need to add delays in between the job starts. We the sever starts jobs it takes up a lot of resources. The server needs more time to recover. Add a sleep between starting these jobs. You can easily overwhelm a computer wit...

I would use this SQL in a UV stage. Output the results into a staging table then you can report on it any way you want. EtlStats has jobs like this. I populate ETL_JOB which has the category and a field that says this job is a sequence. DwNav lets you drill down into sequences. So you can go from th...

Awesome. Keep up the good work.

That SQL is based on the job dependencies in job properties page. This is not always accurate. This is more accurate. select DS_JOBS.NAME JobName FMT '40L', DS_JOBOBJECTS.NAME LinkName FMT '30L', EVAL DS_JOBOBJECTS."@RECORD<12>" AS JobActivtyJobName FMT '40L' from DS_JOBOBJECTS, DS_JOBS wh...

Kumar is on the right track. I think the SQL below could be better. I will send a better version later today. SELECT NAME, CATEGORY, EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',31,'X')" AS DEPEND_JOBS FMT '35L', EVAL "if TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT...

Everything but the sequences should work.

Kumar The poster says he is on Windows and Server only no PX. Windows makes a big difference. One machine means no network traffic after you have done your extracts. 1. DataStage server and Target database on same machine (rare situation). Not that rare when people want tosave money. You are paying ...

http://www.dsxchange.com/viewtopic.php?t=94738 is another example.

Cammand stage has a bug where you cannot use parameters.. It was fixed in Ds7.5. At least I think it was. Use ExecSH or ExecDOS.

I agree with Ray. There has to be something different. DataStage is very consistent. Maybe your network traffic is a lot worse.