Hi All,
Using DSGetLinkInfo we can capture the Link Count. Is there any way to capture the rows per second of that particular link that appear in the Job Canvas?
Regards,
Sai
Capturing rows Per second
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is a way, but you're going to slow down execution considerably if you try to capture this information while the job is running.
CPU consumption is captured periodically and recorded in various records in the repository table RT_STATUSnnn for job number nnn. So, however you do it, you're going to need to determine which resource records you need to read, and then to read them. And remember that RT_STATUSnnn is a hashed file, so you have to use an appropriate API to do that.
CPU consumption is captured periodically and recorded in various records in the repository table RT_STATUSnnn for job number nnn. So, however you do it, you're going to need to determine which resource records you need to read, and then to read them. And remember that RT_STATUSnnn is a hashed file, so you have to use an appropriate API to do that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How (and when) did you get the elapsed time for the stage?
Be aware that you will only get times reported as at the sampling intervals; elapsed time is not a continuous measure. Statistical error may be quite large for short intervals.
If you regard this as resolved, please mark it so using the green button at the top of the page.
Be aware that you will only get times reported as at the sampling intervals; elapsed time is not a continuous measure. Statistical error may be quite large for short intervals.
If you regard this as resolved, please mark it so using the green button at the top of the page.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,
I was calling the following code after the job completes and so far it has yielded me the expected results i.e. the rows per second in the job canvas are matching the routine output barring decimal values.
$INCLUDE DSINCLUDE JOBCONTROL.H
hJob1=DSAttachJob(Arg1,DSJ.ERRWARN);
Ans=DSGetStageInfo(hJob1,Arg2,DSJ.STAGEELAPSED);
Ans=DSGetLinkInfo(hJob1,Arg2,Arg3,DSJ.LINKROWCOUNT)/Ans;
Reply=Ans
Regards,
Sai
I was calling the following code after the job completes and so far it has yielded me the expected results i.e. the rows per second in the job canvas are matching the routine output barring decimal values.
$INCLUDE DSINCLUDE JOBCONTROL.H
hJob1=DSAttachJob(Arg1,DSJ.ERRWARN);
Ans=DSGetStageInfo(hJob1,Arg2,DSJ.STAGEELAPSED);
Ans=DSGetLinkInfo(hJob1,Arg2,Arg3,DSJ.LINKROWCOUNT)/Ans;
Reply=Ans
Regards,
Sai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
After the job is best; I wanted to establish you weren't trying to gather these statistics within the job itself. But beware that the timing still has statistical error for short durations. For a start it's only reported in whole seconds, so (for example) 1.0 means somewhere between 0.5 and 1.5 second.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.