ETLStats - how to obtain correct link counts for PX jobs

hiteshm · Post by **hiteshm** » Fri May 30, 2008 10:04 am

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?

ray.wurlod · Post by **ray.wurlod** » Fri May 30, 2008 3:59 pm

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.