Kbase 21556: Where To Set Database Parameters for the Second Login Broker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2008 |
|
Status: Verified
GOAL:
Where to set database parameters for the second login broker?
GOAL:
What is the impact of database parameters in a configuration where more than one broker will be enabled to handle remote login requests?
FIX:
In a configuration where more than one login broker is required to manage remote connections to the database, the primary broker is responsible for allocating the necessary resources for the database (shared memory structures, OS resources, etc.) based on the parameters specified.
The configuration involving more than one broker is commonly used in a situation where both 4GL and SQL-92 clients simultaneously connect to the database.
In a configuration with more than one broker for the remote connections to the database, and the database is started from the command line, make sure that all parameters related to the database are specified on the primary broker.
For the second broker just limit the parameters passes to the remote connection parameters (such as, -Mpb, -Ma, -Mi, -Mm, etc.). All other parameters, such as -B (for database buffers), will be ignored if specified for the secondary broker.
From the Progress Explorer tool, start the database, the tool itself will distribute the correct parameters for the brokers.