RE: Moving Informix from SCO to Solaris, Need help
Just remember that Solaris cannot have more than 8 slices on one disk. So it is useless to have disks larger than 16 Gig. This is without any RAID configuration. -----Original Message----- From: kho@ADM.com [SMTP:kho@ADM.com] Sent: Wednesday, January 26, 2000 1:33 AM To: informix-list@iiug.org Subject: Re: Moving Informix from SCO to Solaris, Need help 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.
Not useless if you get a volume manager to partition the drives and logical array devices. The limitation is in the Solaris VTOC not the OS itself. Another volume manager, like Veritas VM, can partition the drives or arrays into as many pieces as you need. I have RAID10 arrays made from 20 - 9 GB drives partitioned into 90+ 2GB partitions for Informix using Veritas VM. Art S. Kagel Hannes Visagie wrote: > Just remember that Solaris cannot have more than 8 slices on one disk. So > it is useless to have disks larger than 16 Gig. This is without any RAID > configuration. > > -----Original Message----- > From: kho@ADM.com [SMTP:kho@ADM.com] > Sent: Wednesday, January 26, 2000 1:33 AM > To: informix-list@iiug.org > Subject: Re: Moving Informix from SCO to Solaris, Need help > > 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.
I am confuse, I talked to the sales from Informix, they said the database could be as large as you want, but I saw a few posts talking about database cannot be bigger than 2.0 Giga. !! In article <86m8p6$sso$1@news.xmission.com>, Hannes Visagie <hvisagie@mibco.org.za> wrote: > > Just remember that Solaris cannot have more than 8 slices on one disk. So > it is useless to have disks larger than 16 Gig. This is without any RAID > configuration. > > -----Original Message----- > From: kho@ADM.com [SMTP:kho@ADM.com] > Sent: Wednesday, January 26, 2000 1:33 AM > To: informix-list@iiug.org > Subject: Re: Moving Informix from SCO to Solaris, Need help > > 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. > > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: > I am confuse, I talked to the sales from Informix, they said the > database could be as large as you want, but I saw a few posts talking > about database cannot be bigger than 2.0 Giga. !! No. A single chunk cannot be larger than 2GB. A dbspace is made up of from one to 1024 chunks or 2TB. A single fragments of a single table cannot exceed 16,277,215 pages (32GB on a 2Kpage system, 64GB on 4K page systems) but a table can be fragmented into many fragments each a maximum of 32GB in size. The practical limit, for a 7.xx or 9.xx database is 2TB. For an IDS/XPO server the limit is 2TB per co-server with the number of co-servers comprising the entire database essentially unlimited. Art S. Kagel > In article <86m8p6$sso$1@news.xmission.com>, > Hannes Visagie <hvisagie@mibco.org.za> wrote: > > > > Just remember that Solaris cannot have more than 8 slices on one disk. > So > > it is useless to have disks larger than 16 Gig. This is without any > RAID > > configuration. > > > > -----Original Message----- > > From: kho@ADM.com [SMTP:kho@ADM.com] > > Sent: Wednesday, January 26, 2000 1:33 AM > > To: informix-list@iiug.org > > Subject: Re: Moving Informix from SCO to Solaris, Need help > > > > 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. > > > > > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~ > 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, Have you considered calling the Informix Professional Services Organization to help you with this migration? Alan kho@ADM.com wrote: > I am confuse, I talked to the sales from Informix, they said the > database could be as large as you want, but I saw a few posts talking > about database cannot be bigger than 2.0 Giga. !! > > In article <86m8p6$sso$1@news.xmission.com>, > Hannes Visagie <hvisagie@mibco.org.za> wrote: > > > > Just remember that Solaris cannot have more than 8 slices on one disk. > So > > it is useless to have disks larger than 16 Gig. This is without any > RAID > > configuration. > > > > -----Original Message----- > > From: kho@ADM.com [SMTP:kho@ADM.com] > > Sent: Wednesday, January 26, 2000 1:33 AM > > To: informix-list@iiug.org > > Subject: Re: Moving Informix from SCO to Solaris, Need help > > > > 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. > > > > > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~ > 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.