RE: Moving Informix from SCO to Solaris, Need help
kho 2.0 GB is the upper limit on the size of a chunk. 1 or more chunks make up a dbspace. 1 or more dbspaces make up an instance. An instance can contain 1 or more databases. So imagine a (n oversimplified) scenario such as this: chunk 1 (2 GB) chunk 2 (2 GB) chunk 3 (2 GB) chunk 4 (2 GB) dbspace 1 is composed of chunks 1 and 3. dbspace 2 is composed of chunks 2 and 4 the instance is composed of dbspace 1 and 2. database 1 is 4GB in size and is contained in dbspace 1. database 2 is 3GB in size and is contained in dbspace 2. Clearer? HTH Sujit kho@ADM.com on 01/26/2000 12:06:12 PM Please respond to kho@ADM.com To: informix-list@iiug.org cc: Subject: RE: Moving Informix from SCO to Solaris, Need help 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.