Where are these statistics coming from? Without a frame of reference it is impossible to do anything with these stats. What do you want to get out of them?
ArndW wrote:Where are these statistics coming from? Without a frame of reference it is impossible to do anything with these stats. What do you want to get out of them? ...
This is the perf statistics for a Transformer Stage.
This is a tab-separated report obtained by enabling stage tracing from the Job Run Options dialog when issuing a job run request and checking the Statistics check box.
Copy it from there and paste it into a tool like Excel.
You can use it to identify the "hot spots" within stage execution.
Your statistics have been taken from a Transfomer stage called Trans_FSCM_2_EPM_LN. Each resource (link processing, derivations, evaluations of stage variables, updating stage status in the repository, etc.) shows in the report. You are (except for Count) looking at time; Minimum and Average times are given in rounded microseconds if my memory serves me correctly.
So your Transformer stage spent 92% of its time handling the Collect_And_Sort.SortedData_To_Trans link. You should probably be looking at tuning that part of the operation first. It may be masking problems downstream of itself, but you can't determine that till you've cleared that particular logjam.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:This is a tab-separated report obtained by enabling stage tracing from the Job Run Options dialog when issuing a job run request and checking the Statistics check box.
Copy it from there and paste ...
Well Ray, this is been copy and psted from the logs itself. I am sorry I can't allign them here..