Page 1 of 1

Job Score in Ds

Posted: Mon Jan 26, 2009 9:35 am
by prolifics
Hi All,

I am trying to inspect the Job score from DS director, Can anyone please let me know how we can view the Job score and where can I find it .

Thanks,
Kaps

Posted: Mon Jan 26, 2009 10:03 am
by chulett
Server jobs don't have a "score".

Posted: Mon Jan 26, 2009 10:08 am
by prolifics
chulett wrote:Server jobs don't have a "score".
Thanks for calarification.

Can you please add, if it is parallel jobs ..how we can do it .

Thanks again
Kaps

Posted: Mon Jan 26, 2009 10:14 am
by chulett
Post that question in the Enterprise Edition forum and mark the job type as 'Parallel'. Better yet, try searching that forum as you aren't the first person to ask questions about how to dump and read a score, so what you seek is out there already.

Posted: Mon Jan 26, 2009 10:18 am
by prolifics
chulett wrote:Post that question in the Enterprise Edition forum and mark the job type as 'Parallel'. Better yet, try searching that forum as you aren't the first person to ask questions about how to dump and read a score, so what you seek is out there already.
Thanks, I will surely visit the EE forum,

Thanks again
Kaps

Posted: Mon Jan 26, 2009 10:22 am
by mk_ds09
Hi ,

To understand the dump score, you should have the undestanding of the operators,processes ..you can say the advanced datastage concepts..!

Generally it shows what are
1. What are the operateors datastage is using..and are there any additional operators are included ..
2.it shows keys used and the sorting..here you can avoid the sorting which is superfluous components..
Here job design can be improved..
3.It shows how data is partioned and sorted.
4.It shows what are the datasets created.
5.How data is buffered.
6.What degree is parellelism is achieved by the job and how many operators are running on each nodes..

Most important thing .. you can achieve is the superflous operatores like sorting ..which can cause performance issues and solution to this is to re-design the job..

----------------------------

Hope this helps..

------------

MK