RE: RAW/RAID/2gig limit??

Posted in 2000

Topics: Performance & Tuning, Installation, Setup & Upgrades, Storage & Space Management, Stored Procedures & SPL, Transactions, Locking & Isolation, Platform-Specific Issues

Raj Muralidharan — Wed, 20 Sep 2000 07:05:01 -0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C022FB.01372220 Content-Type: text/plain; charset="iso-8859-1" There are some IDS SQL features (such as optimizer hints, some of the SQL functions) that are unavailable in XPS. Also, you don't have replication capabilities. Only tablespace blobs are possible in XPS. The use of ROWID is not available. There are some neat features in 8.31 that, in my opinion, should be made available to the regular IDS stream. One very cool thing is the concept of '.profile' for users connecting to a database. There is a stored proc that can be written and customized for a user or created for public that will be executed when the session is connected and there is a complementary one for session termination. Raj -----Original Message----- From: Jonathan Leffler [mailto:jleffler@earthlink.net] Sent: Wednesday, September 20, 2000 7:19 AM To: informix-list@iiug.org Subject: Re: RAW/RAID/2gig limit?? 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> ------_=_NextPart_001_01C022FB.01372220 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35"> <TITLE>RE: RAW/RAID/2gig limit??</TITLE> </HEAD> <BODY> There are some IDS SQL features (such as optimizer = hints, some of the SQL functions) that are unavailable in XPS.  = Also, you don't have replication capabilities.   Only = tablespace blobs are possible in XPS.  The use of ROWID is not = available. There are some neat features in 8.31 that, in my = opinion, should be made available to the regular IDS stream.  One = very cool thing is the concept of '.profile' for users connecting to a = database.  There is a stored proc that can be written and = customized for a user or created for public that will be executed when = the session is connected and there is a complementary one for session = termination. Raj -----Original Message----- From: Jonathan Leffler [<A = HREF=3D"mailto:jleffler@earthlink.net">mailto:jleffler@earthlink.net</A>= ] Sent: Wednesday, September 20, 2000 7:19 AM To: informix-list@iiug.org Subject: Re: RAW/RAID/2gig limit?? 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 <A = HREF=3D"http://www.perl.com/CPAN"; = TARGET=3D"_blank">http://www.perl.com/CPAN</A>; #include <disclaimer.h> </BODY> </HTML> ------_=_NextPart_001_01C022FB.01372220--

RE: RAW/RAID/2gig limit??

Related threads

Glossary

Your privacy choices