AIX UNIX v4.3.2 (or .3)
ProIV v4.0 R528

Is there anyone who uses AIX with PROIV? If so what are your isamdef settings. We have run into some major online response issues and in working with PROIV they claim it is our isamdef settings. We have changed, modified, and completely revamped the settings with little or no help from PROIV and with little or no improvements. PROIV says we need to make the shared memory segments larger, but when you make it larger than 32K you get an error message when running the PRO command. ProIV says we need to contact IBM (which we are attempting) on why we can't make the shared memory segments larger than 32k. Can anyone offer some assistance on this? We are stumped and seemed to be getting no where.

Don Mayer
Health Care Data Systems

Don: we have a customer using a G40 with 130 users in a point-of-sale environment and this is their isamdef:

MAXFILES = 400 max # of open isam files
MAXUSERS = 256 max # users in system
USRFILES = 20 max # open files per user
MAXLOCKS = 200 max # of simultaneous rcd locks
AVGLOCK = 64 average size (bytes) of a record lock

We don't use the option to set the Shared Memory size directly.

HOWEVER...what we did stumble on was that the 'Virtual Memory' allocation was 4 Mb and we were running into very high load factors (20+) and by changing this to 64Mb, the improvement in performance was startling.

Now when I make the same changes on our system I get the following error:

/etc/isamdef: Specified parameters exceed maximum allowed lock table size:
required size 103896, max allowed 32767

Does anyone know what this means or know how to fix it?

-Don

I haven't seen this error message before...do you have other options activated in the ISAMDEF?
We're using version 4.0 of Pro-IV with AIX 4.1.1