Re: Number of Light Scan Buffers

Mike Davies wrote: > > I believe the number of Light Scan buffers is dependent upon RA_PAGES and > RA_THRESHOLD but I am not sure of the exact formula. Does anyone know what > this is? Furthermore, are the formulae the same for IDS 7.3 and XPS 8.3? I don't know about XPS, but in IDS the number of light scan buffers is: (RA_PAGES + RA_THRESHOLD) / (MAXAIOSIZE / PAGESIZE) Where MAXAIOSIZE is the max IO size supported on your platform, usually 60 kb. This was for 7.x and could have changed for 9.x. Use onstat -g lsc to monitor. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+