Kbase P7813: Is SQL-92 multithreaded in Progress 9.1D?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
Is SQL-92 multithreaded in Progress 9.1D?
GOAL:
Can more than one SQL-92 client connect to a dedicated Sql-92 server?
GOAL:
Can -Mi be used to achieve multi threaded SQL-92 connections?
FACT(s) (Environment):
Progress 9.1D
FIX:
In 9.1D, the existing -Mi database broker parameter which is used for specifying the number of remote users on a server before the broker starts another one, can be used for enabling the use of multithreaded server of each SQL92 server before another server is spawned.
To do so, set Mi to n (n > 1) to override the default Mi value 1, and also increase the value of the -Ma parameter(default is 5) and -n parameter(default is 21).
For example:
1. Start one SQL92 server with 20 users connected:
PROSERVE [database name] -S [port] -Mi 20 -Mn 1 -Ma 20
2. Start 5 SQL92 servers with at least 5 users connected to each started server:
PROSERVE [database name] -S [port] -Mi 5 -Mn 5 -Ma 10