Our client is having around 140 users connected to databases on Progress 9.1E on AIX 5.3 on IBM P-series server.
They need to know if there are any recommendations by Progress on how parameters (such as paging space, ,memory management) are be set in AIX suited for Progress RDBMS. Please let me know if there such documentation.
This problem is not easy to handle with no details.
A) First contact the TechSupport and open a case:
https://www.progress.com/cgi-bin/techweb-emea.cgi/qtm53/quicklog/usrqklog2.w
B) Second , run this tool on the AIX server to get all informations about the system
(see README) with ProinventoryTool
http://communities.progress.com/pcom/servlet/JiveServlet/download/9242-2-8870/proinv13_aix.tar
C) Copy the *.pf startup parameters files (client and server) and the database structure [dbname].st
D) do an proutil [dbname] -C dbanalys > analys.txt
E) with smitty get the fileSystem block size, default jfs 4096 (4k)
... send all these files to the TechSupport and you will have the answer.
another task to do is to get the file system speed:
cd /whereDatabaseFilesAreLocated
time dd if=/dev/zero bs=1024 count=1024 of=test && sync
Here is a script (ksh) to monitor progress applications system process.
Let him running a couple of days.
With this you can estimate CPU/memory needs or trace application bugs.
1) Upgrade to current release of Progress (i.e. 10.2)
2) Make sure that minperm & maxperm are "low". 5 & 6 are the suggested values in the kbase.
3) The rest is largely a matter of your local situtation or "normal" Progress tuning.