Time Spent on Each stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
Time Spent on Each stage
I know there is a way in which you can check in the log how much time is being spent on each stage. I just can not remember it? Is there an Env variable that needs to be enabled?
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
shouldn't the elapsed time of each match the total time of production or the production time is a sum of something else ? For Example. I join two tables using a join stage and write to a dataset. It comes up with something like this.
?
And why is it showing info regarding the single Join two times with two seprate figuresStage1_0,0: Operator completed. status: APT_StatusOk elapsed: 2.66 user: 0.08 sys: 0.01 (total CPU: 0.09)
Stage2_0,0: Operator completed. status: APT_StatusOk elapsed: 8.08 user: 1.30 sys: 0.05 (total CPU: 1.35)
Join_16,0: Operator completed. status: APT_StatusOk elapsed: 8.23 user: 0.01 sys: 0.01 (total CPU: 0.02)
Data_Set_26,0: Operator completed. status: APT_StatusOk elapsed: 8.24 user: 0.00 sys: 0.00 (total CPU: 0.00)
Join_16,0: Operator completed. status: APT_StatusOk elapsed: 8.24 user: 0.05 sys: 0.00 (total CPU: 0.05)
main_program: Startup time, 0:07; production run time, 0:08.
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Total production run time includes overheads that are not counted against any one stage (operator). Further, stages are executing simultaneously, so that the elapsed time for any one stage could potentially be the same as (or nearly the same as) the job itself.
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.