Row count always correct?

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
rradunz
Participant
Posts: 2
Joined: Wed Aug 02, 2006 5:54 am
Location: Porto Alegre,RS,Brazil
Contact:

Row count always correct?

Post by rradunz »

When you run a job from inside the Designer you can watch as the row counts are being updated, until all the links turn green and the job ends, right?
Does a black link (showing 0 rows, 0 rows/sec) mean a particular section did not run?
The resulting data contains every column it should, including those created in the section that did not run...
Is this a known bug?
Thanks!
There are no problems, only opportunities!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Does that section include a connection to a Shared Container? Those will (unfortunately) never show counts on the canvas.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Under certain circumstances other links also are not updated, for example the output link from a Modify stage. The display of "performance statistics" in Designer was only ever a marketing gimmick; prefer the Director client "stage finishing" messages, or Monitor, to get row counts (if not the API). The Monitor can optionally give you separate row counts for each partition.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Still you cannot completly rely on the this performance staticts. The Environmental varialbe Setting in DS Administrator might change this character.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
rradunz
Participant
Posts: 2
Joined: Wed Aug 02, 2006 5:54 am
Location: Porto Alegre,RS,Brazil
Contact:

Post by rradunz »

Not a Shared Container, but the output from a Modify stage, yes.
Since I am new to DS, I thought the stage wasn't being run.
Many thanks to DSXchange and your prompt replies!
There are no problems, only opportunities!
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

rradunz wrote:Not a Shared Container, but the output from a Modify stage, yes.
Since I am new to DS, I thought the stage wasn't being run.
Many thanks to DSXchange and your prompt replies!

Is it a two modify stage, condected next to next?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That's not the only scenario. Modify ---> Peek will also not report a row count to the Designer.
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