# of uvsh.exe s running
Moderators: chulett, rschirm, roy
# of uvsh.exe s running
Is it normal to have more uvsh.exe running than the # of jobs. We had some "hung" jobs and looking at the Win Task Manager the we see 10 uvsh.exe s even though we are running only 2 DS jobs..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not abnormal.
For example, a job with multiple active stages may start a separate process for each active stage, as well as the controlling process that is actually running the job.
Connected clients may also temporarily use uvsh processes, for example when compiling.
For example, a job with multiple active stages may start a separate process for each active stage, as well as the controlling process that is actually running the job.
Connected clients may also temporarily use uvsh processes, for example when compiling.
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.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Does it means that if i have 10 stages in one job then may haapen that for that job 10 uvsh.exe s will be called??
If yes then what are then ways to reduce it or something like that as if i want to run many job at a same time i will be loading the server with many number of exes and making it too slow.
If yes then what are then ways to reduce it or something like that as if i want to run many job at a same time i will be loading the server with many number of exes and making it too slow.
ray.wurlod wrote:It's not abnormal.
For example, a job with multiple active stages may start a separate process for each active stage, as well as the controlling process that is actually running the job.
Connected clients may also temporarily use uvsh processes, for example when compiling.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
I got that chulett what I said was IT MAY happen that a job may trigger 10 exes and as u say it depends on the job design, What i like to know what are the standars or ways to reduce this means like keep the transaction size low and all.
chulett wrote:The number of Active stages are the key here, not the total number of stages in the job. And Ray did say that they may start separate processes, it depends on your job design (amongst other things).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The number of uvsh processes has no effect whatsoever on the transaction size, which is a property in the stage that actuallky loads the database table.
The number of uvsh processes is solely a function of the number of active stages in the job and how these are connected to each other (and, perhaps, whether you are using row buffering).
The number of uvsh processes is solely a function of the number of active stages in the job and how these are connected to each other (and, perhaps, whether you are using row buffering).
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.