Kbase P1788: Exceeding permissible when having a SQL-92 Secondary Boker.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/22/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
SQL-92 connections
Exceeding permissible number of connections
Using a secondary broker for the ODBC connections.
The SQL-92 broker set as the secondary broker.
There are less ODBC users connected to the secondary broker than the -Mn startup parameter for that broker.
CAUSE:
Some of the 4GL users that should connect to the primary broker are connecting to the secondary broker since Progress looks for the -Mi in the primary broker. When all the servers of the primary broker have this -Mi number of users connected (regardless of the -Ma), the primary broker will spawn a server from the secondary broker.
FIX:
In order to maintain the SQL-92 broker as secondary broker:
Increase -Mi in the primary broker in a way that the primary broker's -Mn X -Mi (-Mn multiply by -Mi) is equal to the maximum number of 4GL users that will connect to the DB.