Moving Informix from SCO to Solaris, Need help

We are moving the Informix to a different platform, well not really moving, we are setting up new Informix server on a SUN solaris 7, Does anyone know what kind of hardware requirement need to succefully deploy the Informix on a sparc 250 enterprise running Solaris 7. How would the different hardware/filesys affecting the Informix, 1) For example, if we we have RAID 5 on the box with 50Giga space including the OS, do I need to reserve some raw space before I install the OS for the Informax database to sit on ?? 2) If not how would I allocate space for the database ?? 3) Does the database mounted to the root as a volume ?? I am not sure I ask the right questions, any info and suggestion are appreciated. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ King Ho <kho@ADM.com> American Direct Mail (ADM) ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sent via Deja.com http://www.deja.com/ Before you buy.

kho@ADM.com wrote: > We are moving the Informix to a different platform, well not really > moving, we are setting up new Informix server on a SUN solaris 7, Does > anyone know what kind of hardware requirement need to succefully deploy > the Informix on a sparc 250 enterprise running Solaris 7. How would the > different hardware/filesys affecting the Informix, > 1) For example, if we we have RAID 5 on the box with 50Giga space > including the OS, do I need to reserve some raw space before I install > the OS for the Informax database to sit on ?? > I would not use RAID5 for ANY database system. It is not secure and it is 50% slower on writes than mirroring (RAID1) or RAID10 (stripped mirrors). To your question, yes you should reserve one or more 2GB disk partitions for Informix RAW chunks. You might be best off creating two stripe sets, one for OS filesystems, rootdbs, and Informix logging dbspaces, and the other for the data chunks. I strongly recommend that these stripe sets be RAID10. > 2) If not how would I allocate space for the database ?? > You could create the Informix chunks as filesystem files but performance will suffer by 20-35% over RAW device space. It is easier to manage, however. > 3) Does the database mounted to the root as a volume ?? No, not RAW space anyway. Solaris need know nothing about the Informix disks at all. Informix is, in effect, its own filesystem manager. > > > I am not sure I ask the right questions, any info and suggestion > are appreciated. Remember that Informix cannot use any disk partition larger than 2GB, for a large drive or array you may need a Volume Manager, like Veritas VM, to divide up the array into many 2GB chunks. Art S. Kagel

Thanks you for your help tips, wondering if this is also true on Solaris 2.6, just looking the quote from the hardware vendor, The OS they quote was Solaris 2.6!! In article <388DEBF0.A876F7C4@bloomberg.net>, "Art S. Kagel" <kagel@bloomberg.net> wrote: > kho@ADM.com wrote: > > > We are moving the Informix to a different platform, well not really > > moving, we are setting up new Informix server on a SUN solaris 7, Does > > anyone know what kind of hardware requirement need to succefully deploy > > the Informix on a sparc 250 enterprise running Solaris 7. How would the > > different hardware/filesys affecting the Informix, > > 1) For example, if we we have RAID 5 on the box with 50Giga space > > including the OS, do I need to reserve some raw space before I install > > the OS for the Informax database to sit on ?? > > > > I would not use RAID5 for ANY database system. It is not secure and it is > 50% > slower on writes than mirroring (RAID1) or RAID10 (stripped mirrors). > > To your question, yes you should reserve one or more 2GB disk partitions > for Informix > RAW chunks. You might be best off creating two stripe sets, one for OS > filesystems, > rootdbs, and Informix logging dbspaces, and the other for the data chunks. > I strongly > recommend that these stripe sets be RAID10. > > > 2) If not how would I allocate space for the database ?? > > > > You could create the Informix chunks as filesystem files but performance > will suffer > by 20-35% over RAW device space. It is easier to manage, however. > > > 3) Does the database mounted to the root as a volume ?? > > No, not RAW space anyway. Solaris need know nothing about the Informix > disks at > all. Informix is, in effect, its own filesystem manager. > > > > > > > I am not sure I ask the right questions, any info and suggestion > > are appreciated. > > Remember that Informix cannot use any disk partition larger than 2GB, for a > large > drive or array you may need a Volume Manager, like Veritas VM, to divide up > the > array into many 2GB chunks. > > Art S. Kagel > > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ King Ho <kho@ADM.com> 350 Hudson Street, NY 11014 American Direct Mail (ADM) ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sent via Deja.com http://www.deja.com/ Before you buy.

kho@ADM.com wrote: > Thanks you for your help tips, wondering if this is also true > on Solaris 2.6, just looking the quote from the hardware vendor, > The OS they quote was Solaris 2.6!! Reviewing my response below, it is all true for EVERY OS and version on every platform of which I am aware, regardless of who makes the disk array, etc. Art S. Kagel > > > In article <388DEBF0.A876F7C4@bloomberg.net>, > "Art S. Kagel" <kagel@bloomberg.net> wrote: > > kho@ADM.com wrote: > > > > > We are moving the Informix to a different platform, well not really > > > moving, we are setting up new Informix server on a SUN solaris 7, > Does > > > anyone know what kind of hardware requirement need to succefully > deploy > > > the Informix on a sparc 250 enterprise running Solaris 7. How would > the > > > different hardware/filesys affecting the Informix, > > > 1) For example, if we we have RAID 5 on the box with 50Giga space > > > including the OS, do I need to reserve some raw space before I > install > > > the OS for the Informax database to sit on ?? > > > > > > > I would not use RAID5 for ANY database system. It is not secure and > it is > > 50% > > slower on writes than mirroring (RAID1) or RAID10 (stripped mirrors). > > > > To your question, yes you should reserve one or more 2GB disk > partitions > > for Informix > > RAW chunks. You might be best off creating two stripe sets, one for > OS > > filesystems, > > rootdbs, and Informix logging dbspaces, and the other for the data > chunks. > > I strongly > > recommend that these stripe sets be RAID10. > > > > > 2) If not how would I allocate space for the database ?? > > > > > > > You could create the Informix chunks as filesystem files but > performance > > will suffer > > by 20-35% over RAW device space. It is easier to manage, however. > > > > > 3) Does the database mounted to the root as a volume ?? > > > > No, not RAW space anyway. Solaris need know nothing about the > Informix > > disks at > > all. Informix is, in effect, its own filesystem manager. > > > > > > > > > > > I am not sure I ask the right questions, any info and suggestion > > > are appreciated. > > > > Remember that Informix cannot use any disk partition larger than 2GB, > for a > > large > > drive or array you may need a Volume Manager, like Veritas VM, to > divide up > > the > > array into many 2GB chunks. > > > > Art S. Kagel > > > > > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~ > King Ho <kho@ADM.com> > 350 Hudson Street, NY 11014 > American Direct Mail (ADM) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Sent via Deja.com http://www.deja.com/ > Before you buy.