Kbase P11340: What processes contribute to the -n parameter?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/07/2008 |
|
Status: Verified
GOAL:
What processes contribute to the -n parameter?
GOAL:
Do background writers counts as a user processes?
GOAL:
How is -n calculated?
GOAL:
What users count towards -n?
GOAL:
What processes count against the -n?
GOAL:
Does an APW count towards -n?
GOAL:
Does a BIW count towards -n?
GOAL:
Does an AIW count towards -n?
GOAL:
Does a watchdog (WDOG) count towards -n?
GOAL:
Does probkup online count towards -n?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
On non-shared memory systems, the -n parameter is used to prevent database server from being overloaded by limiting total number of users.
Shared memory systems use the -n parameter to determine how many semaphores are required upon initialization of the database server. This parameter cannot be tuned while the database server is running.
The -n parameter is a numerical representation of total number of users (local and remote) that will be connected to the database. Background processes such as APWs (Asynchronous Page Writers), BIW (Before Image Writer), AIW (After Image Writer) and WDOG (Watch Dog) available with an Enterprise database license are included in the -n calculation. Each background process started count as 1 user.
You might experience the error 'The server or the system has no more resources. Try a larger -n. (748) if the number of users and background writers/processes reach the -n value.
APWs, BIW, AIW, WDOG promon and probkup online all count towards -n (number of users). Therefore, the -n should be set high enough to take these processes into account.
Note that the promon > 5. Activity can be sometimes be misinterpreted in this respect, as it doesn't indicate that the AIW, BIW and WDOG count towards -n.