Re: write to disk in cooked files

guest wrote: > > Hi , > When we are using cooked files , when a write is issued by informix to the > OS "UNIX" it returns a write successful . Now my question is where exactly is > the write performed i.e to the buffer or to the disk ? Well, the point is, you don't know. And becuase you can't be certain that the write HAS actually gone to disk, as Informix assumes it has, you have potential data integrity problems. This is why, correctly in my opinion, Informix recommend that you use raw disk for important (ie non-development) systems. An exception is, arguably, temporary dbspaces. Neil Truby Chase Manhattan Bank Bournemouth, UK