how to see how many rows each node process

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
times29
Premium Member
Premium Member
Posts: 202
Joined: Mon Sep 22, 2008 3:47 pm

how to see how many rows each node process

Post by times29 »

Hi,
How can i see how may rows each node is processing.

Thanks
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Re: how to see how many rows each node process

Post 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.
times29
Premium Member
Premium Member
Posts: 202
Joined: Mon Sep 22, 2008 3:47 pm

Post 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,
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Quite the opposite, actually.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

The 'number of rows' for nodes show only on the 'target' stages and not on the 'intermediate stages'.

Regards
Sreeni
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Right click in the background of Monitor to enable "Show Instances".

Monitor DOES show intermediate stages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
times29
Premium Member
Premium Member
Posts: 202
Joined: Mon Sep 22, 2008 3:47 pm

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply