Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL and Advanced Business Language Interoperability : Managing Open Edge SQL and ABL database connections : Starting SQL and ABL brokers
 

Starting SQL and ABL brokers

Identify your brokers as either primary or secondary. The primary broker should always be the one with the highest value for -Ma.
For the broker, invoke PROSERVE with the following:
*Set -Ma to the maximum number of users
*Set -Mpb to the maximum number of servers for this broker
*Set -ServerType
For example, use the following command to start an ABL (4GL) primary broker:
proserve Sports2002 -H localhost -S 6001 -ServerType 4GL -n 200 -Mn 7 -Mi 3 -Ma 3 -Mpb 4
Note: The database name specified by a client must be the same database name that was used to start the database server. The name of the OpenEdge programming language has changed from 4GL to Advanced Business Language (ABL). In some instances, such as the designation of server types, the programming language still uses the term "4GL."
proserve Sports2002
Starts the Sports2002 database.
-H localhost
Specifies the machine on which the server runs.
-S 6001
Specifies 6001 as the port number to be used when connecting to a broker process.
-ServerType
Specifies the server type.
-n 200
Limits the number of users to 200.
-Mn 7
Specifies 7 as the maximum number of servers.
-Mi 3
Limits the server to three clients.
-Mpb 4
Restricts the number of servers that can be spawned by the broker to 4.
For the secondary broker, invoke PROSERVE with the following:
*Use -m3 to start up this broker
*Use the -n and -Mn results from the formula above
*Set -Ma to the maximum number of SQL users
*Set -Mpb to the maximum number of servers for this SQL broker
*Set -ServerType to SQL
For example, use the following command to start an OpenEdge SQL secondary broker:
proserve Sports2001 -H localhost -S 6000 -ServerType SQL -n 200 -Mi 6 -Ma 3 -Mpb 2 -m3
proserve Sports2001
Starts the Sports2001 database
-H localhost
Specifies the machine on which the server runs
-S 6000
Specifies 6000 as the port number to be used when connecting to a broker process
-ServerType SQL
Specifies the server type as SQL
-n 200
Limits the number of users to 200
-Mi 6
Limits the server to six clients
-Ma 3
Specifies 3 as the maximum number of servers
-Mpb 2
Restricts the number of servers that can be spawned by the broker to 2
-m3
Identifies the SQL broker as the secondary broker
* Establishing an encrypted connection