Page 1 of 1

how to see how many rows each node process

Posted: Thu Feb 25, 2010 10:12 am
by times29
Hi,
How can i see how may rows each node is processing.

Thanks

Re: how to see how many rows each node process

Posted: Thu Feb 25, 2010 10:30 am
by Nagin
times29 wrote:Hi,
How can i see how may rows each node is processing.

Thanks
You can get that information from Job Monitor in the Director. Right click on the job and click Monitor. It will give you the number of rows each partition is processing.

Posted: Thu Feb 25, 2010 11:03 am
by times29
Hi,
Montior just tells you how many rows are getting insert or updated , Never tells you how many rows are processed by each node,

Posted: Thu Feb 25, 2010 11:04 am
by chulett
Quite the opposite, actually.

Posted: Thu Feb 25, 2010 11:33 am
by Sreenivasulu
The 'number of rows' for nodes show only on the 'target' stages and not on the 'intermediate stages'.

Regards
Sreeni

Posted: Thu Feb 25, 2010 3:58 pm
by ray.wurlod
Right click in the background of Monitor to enable "Show Instances".

Monitor DOES show intermediate stages.

Posted: Tue Jun 01, 2010 12:36 pm
by times29
Ya this is score i am getting from production , So what will be next step
now as apt configruation file has 2 nodes
Message:
main_program: This step has no datasets.
It has 1 operator:
op0[1p] {(parallel APT_CombinedOperatorController:
(DMT_DATE_DM)
(Peek)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.

Posted: Tue Jun 01, 2010 4:43 pm
by ray.wurlod
Your job is only running on one node (for whatever reason) so that your expectation to see row counts for more than one node is unreasonable.