Page 1 of 1

ETLStats - how to obtain correct link counts for PX jobs

Posted: Fri May 30, 2008 10:04 am
by hiteshm
I trying to run the job DSJobReportDb within the ETLStats suite.

I'm trying to obtain the row count for a parallel job.

But since the parallel job has been run on 4 nodes and I'm finding that the row counts in the table ETL_ROW_HIST contains the values for only 1 partition instead of the complete load.

Is this something that anyone has expereinced?

Posted: Fri May 30, 2008 3:59 pm
by ray.wurlod
Read the help for DSGetLinkInfo(). It can obtain single node count or total count. You can adapt ETLStats routines to suit a particular need. That said, I am surprised at your assertion, and await Kim's response to it.