RE: Informix: Informix cooked files filesystem layout

Stavros; I would have one dbspace for rootdbs and temp dbsoaces, a PLOG dbspace for the physical log, a separate dbspace for your logical logs, then at least one dbspace for tables and another at a wide pagesize for any non-trivially small indexes. How many filesystems you use for that is up to you. Remember that between 30 & 50% of your IOs will be to the logical logs and, depending on your apps, up to 30% to the temp dbspaces! I agree with Henri about setting DIRECT_IO to include your temp dbspaces. 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]