Unix Technical Forum

Re: lock table overflow

This is a discussion on Re: lock table overflow within the Informix forums, part of the Database Server Software category; --> The customer's server has 1GB of ram. Unfortuately, it also is the web server, so IIS is running on ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 07:29 PM
Bill Hamilton
 
Posts: n/a
Default Re: lock table overflow


The customer's server has 1GB of ram.
Unfortuately, it also is the web server, so IIS is running on it.

I upped the buffers to 400 and the locks to 40000.
The service reported:
08:47:27 Onconfig parameter RA_PAGES modified from 4 to 8.
08:47:27 Onconfig parameter RA_THRESHOLD modified from 2 to 4.

I don't know how far I should push it.
>
> Only 200 BUFFERS seems a bit too few . . .. how much physical memory
> is on your server?
>
> Any way to see what process is hitting the ovrlock condition??
>


sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:26 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com