Progress
Database Administration
Guide and Reference


Minimum Clients Per Server (-Mi)

Operating 
System 
and Syntax 
UNIX 
NT 
-Mi n 
Use 
With 
Maximum 
Value 
Minimum 
Value 
Single-user 
Default 
Multi-user 
Default 
DBS
1
1

n

The number of remote users on a server before the broker starts another server. See the "Maximum Servers (-Mn)" section.

Use Minimum Clients per Server (-Mi) to specify the number of remote users on a server before the broker starts another server (up to the maximum number of servers). In addition, -Mi and -Mn apply only to databases that are accessed from remote network nodes.

As remote users enter the database, the broker process starts just one server process for each n remote users, until the maximum number of servers (specified by the -Mn parameter) is started. If you specify a value of 1, the broker starts a new server for each of the first -Mn remote users. Subsequent remote users are distributed evenly among the servers until the maximum number of users (-n) or maximum clients per server (-Ma) limits are reached.

NOTE: If you are using SQL-92, you do not need to use -Mi because the limit is always one client per server.

Typically, you can leave -Mi and -Mn at their default values. If you significantly increase -Mn, you should also increase -Mi. For example, if you set -Mn to 10 to accommodate up to 40 or more remote users, increase -Mi to 3 or 4 to prevent a situation where 10 servers were started for just 10 remote users.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095