Job Score in Ds

prolifics · Post by **prolifics** » Mon Jan 26, 2009 9:35 am

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

chulett · Post by **chulett** » Mon Jan 26, 2009 10:03 am

Server jobs don't have a "score".

prolifics · Post by **prolifics** » Mon Jan 26, 2009 10:08 am

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

chulett · Post by **chulett** » Mon Jan 26, 2009 10:14 am

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.

prolifics · Post by **prolifics** » Mon Jan 26, 2009 10:18 am

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

mk_ds09 · Post by **mk_ds09** » Mon Jan 26, 2009 10:22 am

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