Number of Pages per Partition
A user on IDS 9.40 was hitting the 16,777,215-page-per-partition limit and asked whether IDS 10 or 11.1 raised it. Respondents (including an IBM kernel developer) confirmed the limit is unchanged and no change was planned. Two workarounds were offered: fragment the table into multiple partitions, which from version 10 onward can all reside in the same dbspace, and use larger page sizes (4K/8K/16K instead of Solaris's 2K) so each partition holds more data. The poster accepted these as reasons to upgrade.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello All, We have occasionally hit the maximum number of pages per partition (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in vain to see if this limit changes in 10.0 or 11.1. It looks like it is still the same limit in 10.0, but I am not sure. Does anyone know if this limit changes in IDS 10.0 or 11.1? Thanks Rob Schmitz Embarq Data Management rob.b.schmitz@embarq.com http://www.embarq.com/
The limit has not changed. You have to option of fragmenting the table into multiple fragments and in 10 & 11 the fragments can all live in the same dbspace, so the limit is really not any physical limit on table size. IB there are no plans to overcome that limit. Art ----- Original Message ----- From: Rob B Schmitz <ids@iiug.org> To: ids@iiug.org At: 10/11 11:08:51 Hello All, We have occasionally hit the maximum number of pages per partition (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in vain to see if this limit changes in 10.0 or 11.1. It looks like it is still the same limit in 10.0, but I am not sure. Does anyone know if this limit changes in IDS 10.0 or 11.1? Thanks Rob Schmitz Embarq Data Management rob.b.schmitz@embarq.com http://www.embarq.com/ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Another work-around is to rebuild the table with maybe 8k pages ( IDS 10). That gives you less pages per "partition". Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Thursday, October 11, 2007 11:18 AM To: ids@iiug.org Subject: Re:Number of Pages per Partition [10119] The limit has not changed. You have to option of fragmenting the table into multiple fragments and in 10 & 11 the fragments can all live in the same dbspace, so the limit is really not any physical limit on table size. IB there are no plans to overcome that limit. Art ----- Original Message ----- From: Rob B Schmitz <ids@iiug.org> To: ids@iiug.org At: 10/11 11:08:51 Hello All, We have occasionally hit the maximum number of pages per partition (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in vain to see if this limit changes in 10.0 or 11.1. It looks like it is still the same limit in 10.0, but I am not sure. Does anyone know if this limit changes in IDS 10.0 or 11.1? Thanks Rob Schmitz Embarq Data Management rob.b.schmitz@embarq.com http://www.embarq.com/ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
The limit on one partition is still the same - 16 million pages - with 10.00 and 11.10, but you can create multiple partitions for the same ta= ble in a single dbspace from 10.00 onwards. Regds, Uday. ---------------------------------- Uday Kale E-Mail : udayk@us.ibm.com Informix Kernel Development IBM Information Management Group ---------------------------------- = "Schmitz, Rob B = [EQ]" = <Rob.B.Schmitz@Em = To barq.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect Number of Pages per Partition = [10118] = 10/11/2007 10:08 = AM = = = Please respond to = ids@iiug.org = = = Hello All, We have occasionally hit the maximum number of pages per partition (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in= vain to see if this limit changes in 10.0 or 11.1. It looks like it is still the same limit in 10.0, but I am not sure. Does anyone know if this limit changes in IDS 10.0 or 11.1? Thanks Rob Schmitz Embarq Data Management rob.b.schmitz@embarq.com http://www.embarq.com/ ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
On 11/10/2007, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote: > The limit has not changed. You have to option of fragmenting the table into > multiple fragments and in 10 & 11 the fragments can all live in the same > dbspace, so the limit is really not any physical limit on table size. IB there > are no plans to overcome that limit. > > Art > > ----- Original Message ----- > From: Rob B Schmitz <ids@iiug.org> > To: ids@iiug.org > At: 10/11 11:08:51 > > Hello All, > > We have occasionally hit the maximum number of pages per partition > (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in > vain to see if this limit changes in 10.0 or 11.1. It looks like it is > still the same limit in 10.0, but I am not sure. Does anyone know if > this limit changes in IDS 10.0 or 11.1? > > Thanks > > Rob Schmitz > Embarq Data Management > rob.b.schmitz@embarq.com > > http://www.embarq.com/ > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > With 10 and above you also have the option of setting larger page sizes (Solaris is particularly poor with only a 2k page size normally). So you can have 16 M page at 4, 8, 12, 16 etc k pages. Keith
Thanks everyone for the information and suggestions. The new capabilities to partition within a dbspace and specify page sizes in 10 and 11 are more reasons to upgrade! Rob Schmitz Embarq Data Management rob.b.schmitz@embarq.com http://www.embarq.com/ -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Keith Simmons Sent: Thursday, October 11, 2007 10:50 AM To: ids@iiug.org Subject: Re: Number of Pages per Partition [10123] On 11/10/2007, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote: > The limit has not changed. You have to option of fragmenting the table into > multiple fragments and in 10 & 11 the fragments can all live in the same > dbspace, so the limit is really not any physical limit on table size. IB there > are no plans to overcome that limit. > > Art > > ----- Original Message ----- > From: Rob B Schmitz <ids@iiug.org> > To: ids@iiug.org > At: 10/11 11:08:51 > > Hello All, > > We have occasionally hit the maximum number of pages per partition > (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in > vain to see if this limit changes in 10.0 or 11.1. It looks like it is > still the same limit in 10.0, but I am not sure. Does anyone know if > this limit changes in IDS 10.0 or 11.1? > > Thanks > > Rob Schmitz > Embarq Data Management > rob.b.schmitz@embarq.com > > http://www.embarq.com/ > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > With 10 and above you also have the option of setting larger page sizes (Solaris is particularly poor with only a 2k page size normally). So you can have 16 M page at 4, 8, 12, 16 etc k pages. Keith ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.