Hi everyone.
I am having some issues with my db parameter settings. Some of the clients get disconnected in the afternoon without any warning and can't get back in until I stop/restart ProControl. I am unsure if my configuration is correct. Any help would be greatly appreciated.
We are using Progress version 9.1B on a Dell server with dual 500Mhz processors and 512MB ram.
We have 15 users, and each of those users can also connect to 2 different Microsoft Access databases (via odbc) to produce reports in Microsoft Access. (does this mean -n should be 45?)
The database.lg file states (even though these parameters are not set in ProControl startup or the pf file, so I'm not sure where they come from)
Number of Database Buffers (-B): 35000. (4239)
Excess Shared Memory Size (-Mxs): 16390. (4240)
Current Size of Lock Table (-L): 150016. (4241)
Current Spin Lock Tries (-spin): 8000. (4243)
Number of Before-Image Buffers (-bibufs): 5. (4252)
Maximum Number of Clients Per Server (-Ma): 5. (4257)
Maximum Number of Servers (-Mn): 5. (4258)
Minimum Clients Per Server (-Mi): 1. (4259)
Maximum Number of Users (-n): 21. (4260)
I am having some issues with my db parameter settings. Some of the clients get disconnected in the afternoon without any warning and can't get back in until I stop/restart ProControl. I am unsure if my configuration is correct. Any help would be greatly appreciated.
We are using Progress version 9.1B on a Dell server with dual 500Mhz processors and 512MB ram.
We have 15 users, and each of those users can also connect to 2 different Microsoft Access databases (via odbc) to produce reports in Microsoft Access. (does this mean -n should be 45?)
The database.lg file states (even though these parameters are not set in ProControl startup or the pf file, so I'm not sure where they come from)
Number of Database Buffers (-B): 35000. (4239)
Excess Shared Memory Size (-Mxs): 16390. (4240)
Current Size of Lock Table (-L): 150016. (4241)
Current Spin Lock Tries (-spin): 8000. (4243)
Number of Before-Image Buffers (-bibufs): 5. (4252)
Maximum Number of Clients Per Server (-Ma): 5. (4257)
Maximum Number of Servers (-Mn): 5. (4258)
Minimum Clients Per Server (-Mi): 1. (4259)
Maximum Number of Users (-n): 21. (4260)
