Kbase P119230: Implement same parameters for all database servers
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Implement same parameters for several database servers
GOAL:
Database Server parameters in one file
FIX:
The startup parameters for a Database can be stored within a file which will be referenced in the startup command, using the -pf option.
For example:
1. Have a "server.pf" file containing
-n 100
-Mn 20
-Ma 4
-minport 3000
-maxport 5000
2. Start 3 databases referencing server.pf
proserve db1 -pf server.pf -B 10000 -L 9000
proserve db2 -pf server.pf -B 5000 -L 5000
proserve db3 -pf server.pf -B 5000 -L 4000
Another option could be to edit the file $DLC/startup.pf and add there the new common startup parameters. However caution is needed then as the added parameters will be used to all Progress sessions. For example, having added "-B 5000" in $DLC/startup.pf would affect badly performance for PROUTIL or request too much memory for single user sessions.