How to optimize AIX5.3 for progress database

Posted by Admin on 23-Jul-2009 06:13

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.

All Replies

Posted by rstanciu on 23-Jul-2009 06:46

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.

Posted by Admin on 23-Jul-2009 07:50

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

Posted by Admin on 23-Jul-2009 08:20

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.

Posted by ChUIMonster on 23-Jul-2009 12:00

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.

This thread is closed