Re: RAW/RAID/2gig limit??
On Tue, 19 Sep 2000, Don Coburn wrote: >I have Solaris 7 (Intel) with Infx 7.31. I want to >use all or most of my 128 Gig RAID Array for raw chunks. > >Am I going to hit the 2 gig limitation on chunk sizes? Yes. >If so is there a way around the limitation? Upgrade to XPS 8.31 now or wait for 9.3 (sometime later this year or early next year). >How do I utilize my entire array for raw chunks for Informix. You'll need all or most of 64 separate partitions, each of 2 GB. Yes, I hear your pain -- I'm just not empowered to do more than sympathize. Oh, and you can't use offsets either; the sum of offset and length can't exceed 2 GB. I remember the good old days when the 100 MB drives were the big ones! -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"
In article <8q8s54$19a$1@news.xmission.com>, Jonathan Leffler <Jonathan.Leffler@informix.com> wrote: > > On Tue, 19 Sep 2000, Don Coburn wrote: > >I have Solaris 7 (Intel) with Infx 7.31. I want to > >use all or most of my 128 Gig RAID Array for raw chunks. > > > >Am I going to hit the 2 gig limitation on chunk sizes? > > Yes. > > >If so is there a way around the limitation? > > Upgrade to XPS 8.31 now or wait for 9.3 (sometime later this year or > early next year). Any change that a draft list of new features in 9.3 be published ? Thanks, Thanh > > >How do I utilize my entire array for raw chunks for Informix. > > You'll need all or most of 64 separate partitions, each of 2 GB. Yes, I > hear your pain -- I'm just not empowered to do more than sympathize. > > Oh, and you can't use offsets either; the sum of offset and length can't > exceed 2 GB. I remember the good old days when the 100 MB drives were > the big ones! > > -- > Yours, > Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> > Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN > "I don't suffer from insanity; I enjoy every minute of it!" > > Sent via Deja.com http://www.deja.com/ Before you buy.
In article <8q8s54$19a$1@news.xmission.com>, Jonathan Leffler <Jonathan.Leffler@informix.com> wrote: > > On Tue, 19 Sep 2000, Don Coburn wrote: > >I have Solaris 7 (Intel) with Infx 7.31. I want to > >use all or most of my 128 Gig RAID Array for raw chunks. > > > >Am I going to hit the 2 gig limitation on chunk sizes? > > Yes. > > >If so is there a way around the limitation? > > Upgrade to XPS 8.31 now or wait for 9.3 (sometime later this year or > early next year). Hey Jonathan, so If you are running XPS 8.31 on a single node,you gain big chunks and XPS's other data management goodies (not to mention multi node expandability), but is there anything you give up these days, that UDS 7.x can do that XPS 8.x can't? -jrg Sent via Deja.com http://www.deja.com/ Before you buy.
jrg@dbengines.com wrote: > Jonathan Leffler <Jonathan.Leffler@informix.com> wrote: > > On Tue, 19 Sep 2000, Don Coburn wrote: > > >I have Solaris 7 (Intel) with Infx 7.31. I want to > > >use all or most of my 128 Gig RAID Array for raw chunks. > > > > > >Am I going to hit the 2 gig limitation on chunk sizes? > > > > Yes. > > > > >If so is there a way around the limitation? > > > > Upgrade to XPS 8.31 now or wait for 9.3 (sometime later this year or > > > early next year). > Hey Jonathan, so If you are running XPS 8.31 on a single node,you > gain big chunks and XPS's other data management goodies (not > to mention multi node expandability), but is there anything you give > up these days, that UDS 7.x can do that XPS 8.x can't? Not much that I know of, but I've not been formally briefed/trained on the differences between 7.31 and 8.31. If I was looking for problem areas, then I'd look at things like the SQL-92 syntax additions made in 7.3x. I know XPS has CASE (and had it before IDS did). XPS now has blobs and stored procedures; the 8.2x and earlier versions did not. XPS does not support unlogged databases -- if you try a plain 'CREATE DATABASE xyz', the database will have a transaction log. DBD::Informix detects the XPS server and doesn't try to run the unlogged database test on it. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>
What about - triggers - subquery flattening - enhancements to 2 digit dates processing. Jonathan Leffler wrote in message <39C89D10.64D46FAB@earthlink.net>... >jrg@dbengines.com wrote: > >> Jonathan Leffler <Jonathan.Leffler@informix.com> wrote: >> > On Tue, 19 Sep 2000, Don Coburn wrote: >> > >I have Solaris 7 (Intel) with Infx 7.31. I want to >> > >use all or most of my 128 Gig RAID Array for raw chunks. >> > > >> > >Am I going to hit the 2 gig limitation on chunk sizes? >> > >> > Yes. >> > >> > >If so is there a way around the limitation? >> > >> > Upgrade to XPS 8.31 now or wait for 9.3 (sometime later this year or >> >> > early next year). >> Hey Jonathan, so If you are running XPS 8.31 on a single node,you >> gain big chunks and XPS's other data management goodies (not >> to mention multi node expandability), but is there anything you give >> up these days, that UDS 7.x can do that XPS 8.x can't? > >Not much that I know of, but I've not been formally briefed/trained on >the differences between 7.31 and 8.31. If I was looking for problem >areas, then I'd look at things like the SQL-92 syntax additions made in >7.3x. I know XPS has CASE (and had it before IDS did). XPS now has >blobs and stored procedures; the 8.2x and earlier versions did not. XPS >does not support unlogged databases -- if you try a plain 'CREATE >DATABASE xyz', the database will have a transaction log. DBD::Informix >detects the XPS server and doesn't try to run the unlogged database test >on it. > >-- >Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) >Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN >#include <disclaimer.h> > >