Jump to content


Photo
- - - - -

Isamdef Settings on AIX RS6000


3 replies to this topic

#1 Don Mayer

Don Mayer

    Member

  • Members
  • PipPip
  • 24 posts
  • Gender:Male
  • Location:Dewitt, United States

Posted 29 November 1999 - 01:56 PM

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

#2 James Lolley

James Lolley

    Member

  • Members
  • PipPip
  • 13 posts
  • Gender:Male
  • Location:Guelph, Canada

Posted 29 November 1999 - 03:01 PM

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.

#3 Don Mayer

Don Mayer

    Member

  • Members
  • PipPip
  • 24 posts
  • Gender:Male
  • Location:Dewitt, United States

Posted 29 November 1999 - 03:41 PM

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

#4 James Lolley

James Lolley

    Member

  • Members
  • PipPip
  • 13 posts
  • Gender:Male
  • Location:Guelph, Canada

Posted 29 November 1999 - 04:00 PM

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



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users