Kbase P22549: What users count towards -n?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/12/2003 |
|
Status: Unverified
GOAL:
How is -n calculated?
GOAL:
What users count towards -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?
FIX:
APW, BIW, AIW, WDOG and probkup online all count towards -n. Thus -n should be set high enough to take account of this. They do not count as licensed users, however.
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.
The behaviour can be seen with sports:
1. proserve sports -N tcp -H host -S prosv02 -n 10 -Ma 2 -Mn 2
14:05:29 BROKER 0: Maximum Number of Clients Per Server (-Ma): 2. (4257)
14:05:29 BROKER 0: Maximum Number of Servers (-Mn): 3. (4258)
14:05:29 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
14:05:29 BROKER 0: Maximum Number of Users (-n): 11. (4260)
As expected, -n and -Mn are increased by 1 so that _mprshut will always be able to access the database to shut it down or do probkup online.
2. promon sports. Select 5. Activity and observe the user count entries:
0 Servers, 0 Users (0 Local, 0 Remote, 0 Batch),0 Apws
3. prowdog sports
0 Servers, 0 Users (0 Local, 0 Remote, 0 Batch),0 Apws
4. probiw sports
0 Servers, 0 Users (0 Local, 0 Remote, 0 Batch),0 Apws
5. proapw sports
0 Servers, 0 Users (0 Local, 0 Remote, 0 Batch),1 Apws
6. mpro sports
0 Servers, 1 Users (1 Local, 0 Remote, 0 Batch),1 Apws
7. mbpro sports -p pause.p
0 Servers, 2 Users (2 Local, 0 Remote, 1 Batch),1 Apws
8. Connected remote client.
1 Servers, 3 Users (2 Local, 1 Remote, 1 Batch),1 Apws
9. Connected remote client.
2 Servers, 4 Users (2 Local, 2 Remote, 1 Batch),1 Apws
10. Connected remote client.
2 Servers, 5 Users (2 Local, 3 Remote, 1 Batch),1 Apws
How many users are currently in the database that affect -n? At this point , altogether 8 - apw, biw, wdog, 2 local, 3 remote.
11. Connected another remote user:
2 Servers, 6 Users (2 Local, 4 Remote, 1 Batch),1 Apws
12. Try to connect another remote user. Get the 748:
The server or the system has no more resources. Try a larger -n. (748)
The behaviour is expected, but the 748 is misleading. -n isn't the problem, but -Mn. The maximum number of servers for remote clients has been reached - all servers are full. But shared memory connections should still be possible. Thus -
13. mpro sports works.
2 Servers, 7 Users (3 Local, 4 Remote, 1 Batch),1 Apws
Note that even though the batch job is listed up separately, this doesn't mean that it is a separate count. Any confusion is the product of the promon interface, which makes it look like e.g. batch jobs are counted separately towards -n. The batch jobs value is just indicating how many of local + remote users are batch jobs.
14. The next mpro sports returns the 5291:
You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291)
15. probkup online sports sportsbak0 also retruns the 5291.
So this is the correct behaviour -
all writers, watchdog and probkup online all count as a user towards -n. Then the local and remote users.