Page 1 of 1

Is there a way to log row count per link/stage level?

Posted: Wed Aug 18, 2010 1:59 pm
by Bostonian
Hi,
If we enable the parameter APT_RECORD_COUNTS then in the director I see the row counts being written as Link Name, node. This means for a 4-nodes environment I will have to sum of DSLinkName,0-4 in order to get count of rows passed in the link.

Instead of that, is there a way to make the director show the total no. of rows in a link without splitting it up by nodes? Thanks.

Posted: Wed Aug 18, 2010 2:12 pm
by Sainath.Srinivasan
Disable the 'show instances' option in monitor to see the 'total's.

Right click and remove the tick.

Posted: Wed Aug 18, 2010 2:17 pm
by Bostonian
That is a good way but is not what I am looking for. This approach only holds good when you use the performance monitor which in turn gives you the count for the latest run.

I am looking for something similar but in the director by which I can see the total counts of the historical runs as well but from director.

Posted: Wed Aug 18, 2010 3:56 pm
by mandyli
You need to write routine for your own.

Posted: Wed Aug 18, 2010 6:32 pm
by ray.wurlod
Performance statistics are not preserved in any location that the Director can access. You can probably access historical performance data in Metadata Workbench (and possibly through the Reporting Console).