Kbase P24896: Exceeding permissible connections error if -Mpb parameter not set correctly.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Making SQL-92 connections to database
Only able to connection a limited number of users
Exceeding permissible number of connections (8933)
Broker could not spawn a server (1157)
CAUSE:
The -Mpb parameter was not set high enough to accommodate the SQL connections.
.
FIX:
The -Mpb limits the number of servers each broker can spawn.
For example, -Mpb 4 limits the number of servers to be spawned to 4.
The -Mpb parameter must be less than the -Mn parameter (Total number of remote servers value)
Increase the -Mpb parameter to reflect the number of SQL-92 users connecting to the database to a maximum of -Mn +1 for each secondary (-m3) login broker.