RE: Informix: Informix cooked files filesystem layout

Stavros: Yes, that arrangement looks mostly OK. I would use a PLOG type space for the physical log rather than a "normal" dbspace, but the benefit of doing that is small, so not a big deal. So, on Linux, you no longer have access to RAW devices on most releases, that is true, but if you upgrade to the latest v14.10 or to v15.0 three is DIRECT_IO support for using cooked devices in addition to using filesystem chunks as long as the pagesize of the dbspace is a multiple of 4K (support for cooked devices that are created with a 4K paging was not included in v14.10 until recently, so you probably need to upgrade). I would want the system, data, and index dbspaces on separate filesystems if I am using filesystem chunks, so I would set up three filesystems, perhaps on separate LVMs. Yes, some users have found that using DIRECT_IO is slower than not enabling it, but in general, most installations do find DIRECT_IO to be faster than using AIO VPs as long as you configure sufficient KAIO resources in the OS. Art You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subscriptions. To unsubscribe from this community discussion, go to [link removed]