Suppose the appdb database must meet the following requirements:

  • Runs on the local computer (localhost).
  • Is accessed by both ABL and SQL users.
  • Uses port 3001 for the ABL broker and port 3101 for the SQL broker.
  • Must support 40 ABL users, 20 SQL users, and 40 other processes.
  • Uses at most 10 servers per ABL broker and 4 servers per SQL broker.
  • Uses at least 2 remote clients per ABL or SQL server.

To support these requirements, you would need to start two brokers: the primary broker to support ABL clients and the secondary broker support SQL clients. To start each broker, you would use a separate PROSERVE command.

To start the primary ABL broker, you would use the following PROSERVE:
proserve appdb –H localhost –S 3001 –n 101 –Mn 15 –Mpb 10 –Ma 4 –Mi 2 –ServerType 4GL

The following table lists each parameter with its description:

Parameter

Description

-H localhost

Specifies that the host on which the database resides is localhost.

-S 3001

Specifies that the port on which the primary broker has to run is 3001.

-n 101

Specifies that the maximum number of users for the database is 101.

40 (ABL) + 20 (SQL) + 40 (other processes) + 1 (secondary broker) = 101

-Mn 15

Specifies the maximum number of servers is 15.

10 (ABL) + 4 (SQL) + 1 (secondary broker) = 15

-Mpb 10

Specifies that the maximum number of ABL servers per broker is 10.

-Ma 4

Specifies that the maximum number of remote ABL clients per server is 4.

-Mi 2

Specifies that the minimum number of remote ABL clients per server before the primary broker starts another server is 2.

-ServerType 4GL

Specifies that the type of server served by the primary broker is ABL.

To start the secondary SQL broker, you would use the following PROSERVE:
proserve appdb –H localhost –S 3101 –Mpb 4 –Ma 5 –Mi 2 –ServerType SQL –m3

The following table lists each parameter with its description:

Parameter

Description

-H localhost

Specifies that the host on which the database resides is localhost.

-S 3101

Specifies that the port on which the secondary SQL broker has to run is 3101.

-Mpb 4

Specifies that the maximum number of SQL servers on the secondary broker is 4.

-Ma 5

Specifies that the maximum number of remote SQL clients per server on the secondary broker is 5.

-Mi 2

Specifies that the minimum number of remote SQL clients per server on the secondary broker is 2.

-ServerType SQL

Specifies that the type of server served by the secondary broker is SQL.

-m3

Starts the secondary broker.