DSXchange

Hi ,

I am collecting statistics of datastage job using datstage macro and share container ..

Is there any way we can capture throughput of particular link i.e rows /sec after its completion..

Please advice ...

Thanks.

Yes. Look for the DSGetLinkInfo() function.

Thanks a lot..i will check it out

Hi ,

I checked DSlinkinfo , but there is no option for no of rows /sec , following r options ...any input is appreciated ...

DSJ_LINKLASTERR
The last error message reported from a link.
DSJ_LINKNAME
Actual name of link.
DSJ_LINKROWCOUNT
The number of rows that have been passed down a link.
DSJ_LINKSQLSTATE
SQLSTATE value from last error message.
DSJ_LINKDBMSCODE
DBMSCODE value from last error message.
DSJ_LINKDESC
Description of the link.
DSJ_LINKSTAGE
Name of the stage at the other end of the link.
DSJ_INSTROWCOUNT
Comma-separated list of row counts, one per instance (parallel jobs)

No there isn't, not explicitly. You'll need to get the LINKROWCOUNT and the elapsed time for the run and do some maths. Use DSGetJobInfo() for the latter.

Hi ,

Elapsed time is the total time for job , I would like to calculate time taken for particular link ..

so the equation would be : No of row for link abc/ time taken to process those rows on abc .

Pl suggest...

However even if you do some maths, that wont be appropriate.

What wouldn't be "appropriate" about it?

If you are going to make statements like that, please also take the time to explain them.

knowledge wrote:Elapsed time is the total time for job , I would like to calculate time taken for particular link

Unless you have a job with a process break then each link runs for the duration of the job. Regardless, someone smarter than me would have to say if there was any place that link start/stop times are recorded.

Hi Craig,

If what you say is right then I will take Elapsed time , which is total time for job ...

So my equation would be :

No of processed rows for particular link /Elapsed time ...

As I said, typically it would be right but not always, depends on the job design and also if buffering is involved. Would be curious what one of the Grognards think...

ok ..Lets wait for their Reply ..

Thanks for your help ...