Memory Management

Hello, I have another question. Again, new to Informix and just doing research for a Linux implementation. Is there a setting that can control the total database memory allowed for Informix to use for all databases and instances (not sure if instance is the right terminology for Informix). I want to restrict memory usage on the machine. So, lets say we have 16GB total memory available on the machine..I want to allow Informix only 3 GB of that. Thanks

shorti wrote: > Hello, I have another question. Again, new to Informix and just doing > research for a Linux implementation. Is there a setting that can > control the total database memory allowed for Informix to use for all > databases and instances (not sure if instance is the right terminology > for Informix). > > I want to restrict memory usage on the machine. So, lets say we have > 16GB total memory available on the machine..I want to allow Informix > only 3 GB of that. Thanks There isn't a way of controlling it across all instances, you manually configure each instance (and an instance can contain multiple databases or schemas.) The main parameters you need to investigate are BUFFERPOOL, SHMVIRTSIZE, SHMADD and SHMTOTAL. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

On Sep 1, 3:26 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > shorti wrote: > > Hello, I have another question.  Again, new to Informix and just doing > > research for a Linux implementation.  Is there a setting that can > > control the total database memory allowed for Informix to use for all > > databases and instances (not sure if instance is the right terminology > > for Informix). > > > I want to restrict memory usage on the machine.  So, lets say we have > > 16GB total memory available on the machine..I want to allow Informix > > only 3 GB of that.  Thanks > > There isn't a way of controlling it across all instances, you manually > configure each instance (and an instance can contain multiple databases > or schemas.) > > The main parameters you need to investigate are BUFFERPOOL, SHMVIRTSIZE, > SHMADD and SHMTOTAL.> > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. Thank you...this is exactly what I was looking for.

shorti wrote: > On Sep 1, 3:26 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: >> shorti wrote: >>> Hello, I have another question. Again, new to Informix and just doing >>> research for a Linux implementation. Is there a setting that can >>> control the total database memory allowed for Informix to use for all >>> databases and instances (not sure if instance is the right terminology >>> for Informix). >>> I want to restrict memory usage on the machine. So, lets say we have >>> 16GB total memory available on the machine..I want to allow Informix >>> only 3 GB of that. Thanks >> There isn't a way of controlling it across all instances, you manually >> configure each instance (and an instance can contain multiple databases >> or schemas.) >> >> The main parameters you need to investigate are BUFFERPOOL, SHMVIRTSIZE, >> SHMADD and SHMTOTAL.>> >> -- >> Cheers, >> Obnoxio The Clown >> >> http://obotheclown.blogspot.com >> I will now proceed to pleasure myself with this fish. >> >> -- >> This message has been scanned for viruses and >> dangerous content by OpenProtect(http://www.openprotect.com), and is >> believed to be clean. > > Thank you...this is exactly what I was looking for. I'm clearly losing my touch. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

> > > Thank you...this is exactly what I was looking for. > > I'm clearly losing my touch. > > -- > Cheers, > Obnoxio The Clown > ok..then I will give you another chance to redeem yourself.....Can anyone tell me what they think of Informix Performance for a larger database...lets say 5-6 + million rows on the main table with multiple other tables with the same amount of rows. Is it better to go with something like Oracle or DB2 instead. I know, I know...I am asking in the Informix forum but seriously..does Informix measure up when it comes to larger databases?

oh..also think around 300 threads connected to this database.

shorti wrote: >>> Thank you...this is exactly what I was looking for. >> I'm clearly losing my touch. >> >> -- >> Cheers, >> Obnoxio The Clown >> > > > ok..then I will give you another chance to redeem yourself.....Can > anyone tell me what they think of Informix Performance for a larger > database...lets say 5-6 + million rows on the main table with multiple > other tables with the same amount of rows. Is it better to go with > something like Oracle or DB2 instead. I know, I know...I am asking in > the Informix forum but seriously..does Informix measure up when it > comes to larger databases? No problem. In fact, better. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

shorti wrote: > oh..also think around 300 threads connected to this database. Woo. Terrifying. :o) I've run bigger sites myself. ;o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

> ok..then I will give you another chance to redeem yourself.....Can > anyone tell me what they think of Informix Performance for a larger > database...lets say 5-6 + million rows on the main table with multiple > other tables with the same amount of rows. Is it better to go with > something like Oracle or DB2 instead. I know, I know...I am asking in > the Informix forum but seriously..does Informix measure up when it > comes to larger databases? My largest OLTP table contains 282 million rows and the engine handles about 3 million transactions per day using 2 dual core CPUs and 3GB of memory for Informix with an average CPU idle of 80-90%. I would classify this as a small to medium sized Informix install, there are much larger Informix installs out there. 5-6 million rows should not be a problem. Andrew

You asked: "Is it better to go with something like Oracle or DB2 instead" Lets say: Its better to go away from those two and move to Informix. It´s just disk layout that may slow down Informix.... Mit freundlichen Grüßen Joerg Volz ----------------------------------------------------------------------------- -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of shorti Sent: Thursday, September 02, 2010 7:29 PM To: informix-list@iiug.org Subject: Re: Memory Management > > > Thank you...this is exactly what I was looking for. > > I'm clearly losing my touch. > > -- > Cheers, > Obnoxio The Clown > ok..then I will give you another chance to redeem yourself.....Can anyone tell me what they think of Informix Performance for a larger database...lets say 5-6 + million rows on the main table with multiple other tables with the same amount of rows. Is it better to go with something like Oracle or DB2 instead. I know, I know...I am asking in the Informix forum but seriously..does Informix measure up when it comes to larger databases? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

On Sep 2, 12:06 pm, Andrew Ford <af...@networkip.net> wrote: > > ok..then I will give you another chance to redeem yourself.....Can > > anyone tell me what they think of Informix Performance for a larger > > database...lets say 5-6 + million rows on the main table with multiple > > other tables with the same amount of rows.  Is it better to go with > > something like Oracle or DB2 instead.  I know, I know...I am asking in > > the Informix forum but seriously..does Informix measure up when it > > comes to larger databases? > > My largest OLTP table contains 282 million rows and the engine handles about > 3 million transactions per day using 2 dual core CPUs and 3GB of memory for > Informix with an average CPU idle of 80-90%. I would classify this as a > small to medium sized Informix install, there are much larger Informix > installs out there. 5-6 million rows should not be a problem. > > Andrew Thanks all..great information. I agree that 6 Million is not really that big since the big RDBMSs can navigate 100's of millions of records but, sorry to say, Informix isnt on the list of the top RDBMSs so I wasnt sure. I will have a different view of Informix from now on. I do have to say that I am pretty impressed by all that I have researched so far and puzzled why it is not in the running with Oracle, DB2 and MS.

Shorti, please send your remark in VERY BIG letters to IBM Management and Marketing! We all will back you up! Regards, Joerg Volz ----------------------------------------------------------------------------- -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of shorti Sent: Thursday, September 02, 2010 9:25 PM To: informix-list@iiug.org Subject: Re: Memory Management On Sep 2, 12:06 pm, Andrew Ford <af...@networkip.net> wrote: > > ok..then I will give you another chance to redeem yourself.....Can > > anyone tell me what they think of Informix Performance for a larger > > database...lets say 5-6 + million rows on the main table with multiple > > other tables with the same amount of rows.  Is it better to go with > > something like Oracle or DB2 instead.  I know, I know...I am asking in > > the Informix forum but seriously..does Informix measure up when it > > comes to larger databases? > > My largest OLTP table contains 282 million rows and the engine handles about > 3 million transactions per day using 2 dual core CPUs and 3GB of memory for > Informix with an average CPU idle of 80-90%. I would classify this as a > small to medium sized Informix install, there are much larger Informix > installs out there. 5-6 million rows should not be a problem. > > Andrew Thanks all..great information. I agree that 6 Million is not really that big since the big RDBMSs can navigate 100's of millions of records but, sorry to say, Informix isnt on the list of the top RDBMSs so I wasnt sure. I will have a different view of Informix from now on. I do have to say that I am pretty impressed by all that I have researched so far and puzzled why it is not in the running with Oracle, DB2 and MS. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

I've run Informix databases with 400,000,000 rows in a table and more. Even before the MACH11 features added the ability to have mulitple shared disk secondary servers to spread the load out and increase scaling WAY beyond anything else out there, Informix already scaled to massive databases and massive numbers of users better than Oracle, Sybase, DB2, SQL Server, etc.... Now? There's no contest. Keep in mind that Informix 11.xx is designed to handle databases up to 128 Petabytes of data! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 2, 2010 at 1:28 PM, shorti <lbryan21@juno.com> wrote: > > > > > Thank you...this is exactly what I was looking for. > > > > I'm clearly losing my touch. > > > > -- > > Cheers, > > Obnoxio The Clown > > > > > ok..then I will give you another chance to redeem yourself.....Can > anyone tell me what they think of Informix Performance for a larger > database...lets say 5-6 + million rows on the main table with multiple > other tables with the same amount of rows. Is it better to go with > something like Oracle or DB2 instead. I know, I know...I am asking in > the Informix forum but seriously..does Informix measure up when it > comes to larger databases? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

I've run Informix databases with 400,000,000 rows in a table and more. Even before the MACH11 features added the ability to have mulitple shared disk secondary servers to spread the load out and increase scaling WAY beyond anything else out there, Informix already scaled to massive databases and massive numbers of users better than Oracle, Sybase, DB2, SQL Server, etc.... Now? There's no contest. Keep in mind that Informix 11.xx is designed to handle databases up to 128 Petabytes of data! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 2, 2010 at 1:28 PM, shorti <lbryan21@juno.com> wrote: > > > > > Thank you...this is exactly what I was looking for. > > > > I'm clearly losing my touch. > > > > -- > > Cheers, > > Obnoxio The Clown > > > > > ok..then I will give you another chance to redeem yourself.....Can > anyone tell me what they think of Informix Performance for a larger > database...lets say 5-6 + million rows on the main table with multiple > other tables with the same amount of rows. Is it better to go with > something like Oracle or DB2 instead. I know, I know...I am asking in > the Informix forum but seriously..does Informix measure up when it > comes to larger databases? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >