Re: Large table extents

costrom@solair1.inter.nl.net (Dutch BGC on-site support) wrote: >minutes to return anything. The Informix chunk we are using is placed on a HP >Logical Volume - I am becoming more suspicious of this every day. > >I am trying to get support for the advice I have given to my employers, that >is - to take Informix away from the Logical Volumes and have seperate disks >for rootdbs, logs and two data dbspaces. 1) Are you sure that you are using the raw logical volume? (/dev/vgxx/r<volname>). 2) HP-UX 10 does not support traditional disk partitioning. Yes, you can write to the disk without going through LVM, but you have to use the whole disk. Overkill, plus you lose the ability to administer what is on that disk. 3) I have had large (>10GB) databases running happily on logical volumes. 4) I concur with the need for separate dbspaces. This is VITAL and nothing to do with logical volumes!, You should also place each critical dbspace on a separate logical volume. You can also place the logical volumes on separate disks (not, I regret, using SAM). Tony -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Tony da Franca, Hewlett Packard UK + + Any views expressed are my own, not Hewlett Packard's + + E-mail: tony_dafranca@hp-unitedkingdom-om7.om.hp.com + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++