Re: Informix buffer size fixed at 2048?

Martin Sandman (martins@sparc.sandiegoca.attgis.com) wrote: : I have leastly begun testing an Informix 7.01 database on an ATT-GIS : SMP system. The test is based on a decision support profile. I ran the : Informix utility onstat -b and got the following: : Buffers : address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist : 0 modified, 25000 total, 32768 hash buckets, 2048 buffer size : Does this mean my physical IO buffer size is set a 2048 bytes? I've looked : for a configuration parameter for buffer size and could not find one. So : is it fixed at 2048? The PAGE SIZE is machine (system) dependent. If you have 200 BUFFERS, this means you will have 409600 bytes of I/O Buffer Pool. Information on the subject can be found in the manual whereever it talk about BUFFERS and/or PAGE SIZE.