Informix & Swap Space Question (DEC Unix)
Posted in 1999
Topics: Performance & Tuning, Jobs, Consulting & Announcements
This is a multi-part message in MIME format. --------------919B8AF49D0ED477BCAE04BA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit We have a Digital Unix system running 3.2g with Informix 7.23FC7. From the Digital Unix System Tuning and Perf. Mgmt. book, it talks about swap allocation modes Deferred and Immediate. Immediate is the default and is currently in use. The book states on page 3-15 that using deferred mode increases performance. The operations folks here stated that they used to use deferred mode but had Informix DB problems, and Informix told them at that time to use immediate mode. They changed to immediate mode and the problems went away. Unfortunately, the person who knows exactly what the problem was has moved on and nobody remembers the exact issue. Does anyone know why Informix recommends using Immediate mode for swap allocation rather than Deferred mode? BTW, this system has 2GB of RAM and does no paging. Thanks, Bert Zahniser and Sushil Shirodkar --------------919B8AF49D0ED477BCAE04BA Content-Type: text/x-vcard; charset=us-ascii; name="bzahniser.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bert Zahniser Content-Disposition: attachment; filename="bzahniser.vcf" begin:vcard n:Zahniser;Bert tel;fax:609-642-2988 tel;work:609-778-8000 ext. 11 x-mozilla-html:FALSE url:http://timebridge.com org:TimeBridge Technologies, Inc. version:2.1 email;internet:bzahniser@timebridge.com title:Enterprise Consultant adr;quoted-printable:;;700 East Gate Drive=0D=0ASuite 240=0D=0A;Mt. Laurel;NJ;08054;USA fn:Bert Zahniser end:vcard --------------919B8AF49D0ED477BCAE04BA--