RE: Experiences with organizing Raw-Devices

>Are there any rules to organize a Raw-Device for an Informix-Database ? > >1. In practice it is useful to place the physical- and logical-logs in the > "rootdbspace". The Databases should be in separate "dbspaces". I have to ask, why place both the physical and logical log in same dbspace?? These are generally being hit alot, so for performance reasons, why not place them in seperate dbspaces, preferrable by themselves. Also, if possible place their respective dbspaces, as near the center of the disk as possible (again, for performance reasons). >2. The LOGspace and the DATAspace should be placed, if possible, on several > harddisks. There are several approaches. Many prefer striping to accomplish this. If you are planning to migrate to 7.x, I would suggest avoiding striping, since the implementation of Fragmentation, does essentially a SQL/data level version of this. The benefit here, is that the server/optimizer knows where the data is. Jon ============================================================= Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ==> ** NOTE NEW ADDRESS _____________________________________________________________ Watch out for road-kill on the information highway....Splat!! =============================================================