Problem
I have installed Progress v9.1 and I am experiencing performance
issues with 90 concurrent users. What tuning is recommended? Solution
The latest version of Progress is v9.1E. This TA was written with
9.1D specifically but will apply equally to earlier and later
versions.Progress 9.1D is supported on UnixWare 7 as well as OpenServer 5.0.5/6 by Progress.
Progress V9.1D08 is certified on SCO OpenServer 5.0.7.
The following packages are required: 1) Get the latest JDK/JRE version for your operating system which
will be downloadable from http://www.sco.com/download and install
using the instructions provided.If you are not sure whether you need Java Development Kit (JDK), the Java Runtime Environment (JRE) or none at all, see the NOTE below.
For example:JDK/JRE 1.3.0_02 available from http://www.sco.com/download In addition, visit ftp://ftpput.sco.com/tmp/java-1.3.0-fixes/
where there are new Java 1.3.0_02 packages with a number of fixes
relative to the Java 1.3.0_02 that shipped with OU8. One of the
problems fixed is a stack leak in the JIT.For earlier releases of UnixWare7, components of the UODK will be
required before JDK can be installed. This will be detailed in the
Java Release Notes that you are trying to install. In addition see:UnixWare and OpenServer Development Kit Feature Supplement available from http://www.sco.com/download
For OpenServer just the OSRcompat part is required (Binary Compatibility Module), and oss630a, The OpenServer 5 UDK Socket Supplement, should also be installed.
For UnixWare7 certain components are required from the UODK so you can either install the full package or the individual packages as detailed in:
TA # 115482, "How do I install Java 2, Standard Edition Version 1.3.0_02 on SCO Open UNIX 8.0.0 and UnixWare 7.1.1?"
2) Tune your UnixWare7 server for sockets in accordance with TA#113164, "My application returns SOCKET accept failed [errno 126] when I try to open over 200 sockets every second." and large file support according to TA#110169, "How to enable large file support?"
3) The following requires knowledge relating to the tuning in addition to the Progress Database tuning:
There's no special tuning required on the system, but it all depends on number of users accessing the application / database and size of the database (ie the used buffer pool), so the following will affect the kernel parameters defined below in /etc/conf/cf.d/stune:
SHMMAX (recommend set to 128 MB) and SHMSEG (recommend to set to 15) - these parameters have influence on -B parameter used by the progress database engline to create / user buffer pool.
SFNOLIM & HFNOLIM should be at maximum -> 2048.
NPROC suggest to set 3000/4000 (depends on number of users)
Also is recommended to use following formula to count value for SEMMSL, SEMMNS and SEMMNU:
Out of all of the databases to be started on the system, take the largest -n setting from the broker startup line and use it in this formula:
SEMMSL = (-n) + 13 The 13 comes from 9 semaphores to start the broker, and 1 for each of
the 4 remote client servers. 9 + 4 = 13. Then you will need 1 for
each user (-n).SEMMNS = SEMMSL * number of db servers to be run on the system.
Set SEMMNS to the value of SEMMSL multiplied by the number of db servers (maximum) that you will be running on the system at one time.
SEMMNU = SEMMNSSet the value of SEMMNU to equal the value of SEMMNS. You could probably set this to about 75% of SEMMNS, but this is a conservative estimate to make them equal.
NOTE: For information on Semaphores and Shared Memory see:http://docsrv.sco.com/SDK_sysprog/CTOC-IPC.htmlhttp://www.cs.cf.ac.uk/Dave/C/node26.htmlNOTE: To see what versions of Progress are supported on what platform, visit:
http://www.progress.com/openedge/products/lifecycle/index.sspNOTE: What components of Java can I install?Java RunTime Environemt (JRE) is free (latest version is 1.3.1_10), available from:
http://www.thescogroup.com/downloadThe Java Development Kit (JDK) is also free but requires some components of the UnixWare OpenServer Development Kit (UODK) to be installed first, ie. libc, libC, libm and urwfonts.
It's best to use the /certified/ Java version as per the product availability and guide reference above.
That's 1.3.0 and 1.3.1 for Progress 9.1D and 1.4.x for 10.0B
So once you've downloaded the Java required, point the $JDKHOME to /opt/[java install] and install Progress.
When you install Progress if it can't find Java on the system it will install a version of Progress that does not use Java calls.
In earlier versions of Progress, (around 9.1B) this was a
fatal installation error. Now, a warning message appears if the
JDKHOME env hasn't been set or can't be found and the
installation proceeds.Even IF you then had selected a COMPLETE install, some components (like the SQL) will NOT be installed as a result.
The Progress install routine needs a Java as the $DLC/java_env file is created through the install routine, which then points to the installed Java version.
How do you decide whether you need JRE or JDK or not?
For example, the SQL-92 engine can run without java if you not
using stored procedures and triggers. If they're using stored
procedures, then they need JRE, for which you will not need any
UODK components.If you are developing stored procedures and triggers, then you'll need the JDK.
NOTE: OpenEdge 10 requires the Java version of 1.4. See also
http://www.progress.com/supporthttp://www.fast4gl.com/downloads/pperform.docTA # 115482, "How do I install Java 2, Standard Edition Version 1.3.0_02 on SCO Open UNIX 8.0.0 and UnixWare 7.1.1?"