media/image3.png

To make a database available for multi-user access, you start at least one broker with appropriate startup parameters using the PROSERVE utility.

The command to start a broker is:
proserve db-name -H host-name -S service-name -n n -Mn n -Mpb n -Ma n -Mi n -ServerType type

Where:

-H host-name

The name or IP address of the host computer that contains the database. It is used for remote client connections.

-S service-name

The service name or port number to be used by a broker. This parameter is required only for remote clients and SQL clients.Valid port range is from 2000 to 32767.

-Mn n

The maximum number of servers that can be started by the broker. It is only required for the primary broker.Default value: 5

To calculate the maximum number of servers in the database, use this formula:

–Mn = (Sum of all –Mpb values) + 1 per secondary broker

-Mpb n

The maximum number of servers per broker.

-Ma n

The maximum number of remote clients per server.Default value: 4Recommended value: 10

-Mi n

The minimum number of remote clients per server before the broker spawns another server.

 
-ServerType type

The type of server. Valid values are 4GL, SQL, and BOTH.Default value: BOTH

Note: 4GL is synonymous with ABL. Use 4GL when you want to start an ABL broker.

Note:
  • All startup parameters are case-sensitive.
  • When you start a broker without specifying the –ServerType parameter, it creates a default broker that caters to both ABL and SQL clients.
  • Even if a client resides on the same computer as the database, the client is treated as a remote client if the hostname, service name, or network type parameters are specified while connecting to a database.
  • SQL clients are treated as remote clients even if they reside on the same computer as the database.
  • You can also start a broker using the _MPROSRV command in either Windows or UNIX. It has the same syntax as PROSERVE.