Isamdef Settings on AIX RS6000
Posted 29 November 1999 - 01:56 PM
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.
Health Care Data Systems
Posted 29 November 1999 - 03:01 PM
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.
Posted 29 November 1999 - 03:41 PM
/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?
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users