throughput of link

knowledge · Post by **knowledge** » Wed Mar 07, 2012 11:13 am

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.

chulett · Post by **chulett** » Wed Mar 07, 2012 1:11 pm

Yes. Look for the DSGetLinkInfo() function.

knowledge · Post by **knowledge** » Thu Mar 08, 2012 10:55 am

Thanks a lot..i will check it out

knowledge · Post by **knowledge** » Fri Mar 09, 2012 8:38 am

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)

chulett · Post by **chulett** » Fri Mar 09, 2012 9:36 am

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.

knowledge · Post by **knowledge** » Sat Mar 10, 2012 12:21 pm

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...

pandeesh · Post by **pandeesh** » Sat Mar 10, 2012 10:44 pm

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

chulett · Post by **chulett** » Sun Mar 11, 2012 7:34 am

What wouldn't be "appropriate" about it?

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

chulett · Post by **chulett** » Sun Mar 11, 2012 7:37 am

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.

knowledge · Post by **knowledge** » Mon Mar 12, 2012 7:44 am

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 ...

chulett · Post by **chulett** » Mon Mar 12, 2012 7:46 am

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...

knowledge · Post by **knowledge** » Mon Mar 12, 2012 8:33 am

ok ..Lets wait for their Reply ..

Thanks for your help ...