datastage log

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

datastage log

Post by pavan_test »

Hi All,

Can someone please let me what these numbers mean?

job design: Fileset ---> transformer --> seq stage

Tfm,1: Operator completed. status: APT_StatusOk elapsed: 1885.14 user: 158.51 sys: 4.72 (total CPU: 163.23)

tfm,0: Operator completed. status: APT_StatusOk elapsed: 1885.22 user: 157.80 sys: 4.68 (total CPU: 162.48)

Thanks
Mark
daignault
Premium Member
Premium Member
Posts: 165
Joined: Tue Mar 30, 2004 2:44 pm
Contact:

Post by daignault »

How much CPU time is being used by your stage. User time is computation time, System time is either time spent doing I/O or Semaphore (System) activity, etc.

Ray D
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

datastage log

Post by pavan_test »

Thank You. The total CPU is : 163.23 This mean the total CPU usage is more than 100%? How so I bring the usuage down to less than 100%

Thanks
Mark
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why do you want to? 160% is an average of 80% each across two CPUs, or 40% each across four CPUs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

And the numbers in the job logs are seconds of CPU, not percentage. The job monitor app in Director will show you CPU percentages, which follow what Ray has mentioned.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

datastage log

Post by pavan_test »

Thanks Ray and James for clarifying.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

:oops:
Missed that. I'm more used to using Monitor to look at %CPU.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply