Re: Not able to increase the extent size?

On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com <calyanram@hotmail.com> wrote: > I am not able to increase the extent size , next size beyond a > particular > level even if specify more number > > what to do? > example > create table test (with 200 columns ) extent size 3902 next size> 1858692 > > > what to check? > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > With what extent sizes is the table being created ? You are asking for an initial extent of 3.9 Mb and a next extent of 1.85 Gb?? Seems to be the wrong way round!! Do you have the contiguous free space available for extents of this size?? How wide is the table and how many rows are you loading? Keith

records is around 5 million table colums are 70 how to check for the contigious space? Keith Simmons wrote: > On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com > <calyanram@hotmail.com> wrote: > > I am not able to increase the extent size , next size beyond a > > particular > > level even if specify more number > > > > what to do? > > example > > create table test (with 200 columns ) extent size 3902 next size> > 1858692 > > > > > > what to check? > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > With what extent sizes is the table being created ? > You are asking for an initial extent of 3.9 Mb and a next extent of 1.85 Gb?? > Seems to be the wrong way round!! Do you have the contiguous free > space available for extents of this size?? How wide is the table and > how many rows are you loading? > > Keith

On 3 Oct 2006 07:01:48 -0700, calyanram@hotmail.com <calyanram@hotmail.com> wrote: > records is around 5 million > table colums are 70 > > how to check for the contigious space? > > > Keith Simmons wrote: > > On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com > > <calyanram@hotmail.com> wrote: > > > I am not able to increase the extent size , next size beyond a > > > particular > > > level even if specify more number > > > > > > what to do? > > > example > > > create table test (with 200 columns ) extent size 3902 next size> > > 1858692 > > > > > > > > > what to check? > > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-list@iiug.org > > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > > > With what extent sizes is the table being created ? > > You are asking for an initial extent of 3.9 Mb and a next extent of 1.85 Gb?? > > Seems to be the wrong way round!! Do you have the contiguous free > > space available for extents of this size?? How wide is the table and > > how many rows are you loading? > > > > Keith > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > This would appear to be approx. a 2Gb table. You do not say which engine you have, so assuming you still have a 2Gb chunk limit and a 'normal' growth of 20% per annum I would suggest placing this table in its own (new) dbspace with an extent size of 4900000 and a next size of 2500000. Detached indexes would also be a good idea. You can check for contiguouc space with oncheck -?? database:table (sorry, poor memory and no manual to hand) or oncheck -pe for the entire instance. Keith

I use a script which checks for contiguous free space. It queries the sysmaster syschfree table. Any self-respecting database administrator can easily work out the script. I would provide it but I'm not in the office and so don't have all the details to hand. Generally I find that the amount of free space is fairly segmented just a few weeks after creating the dbspace. Especially if databases and/or tables and indexes are added and dropped. But you don't say which hardware platform, operating system, or IDS version. That information could be very relevant as there is a maximum chunk size of 2Gbytes on early versions and that artificially limits the extent size as extents cannot span chunks. Regards Malcolm -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of calyanram@hotmail.com Sent: 03 October 2006 15:02 To: informix-list@iiug.org Subject: Re: Not able to increase the extent size? records is around 5 million table colums are 70 how to check for the contigious space? Keith Simmons wrote: > On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com > <calyanram@hotmail.com> wrote: > > I am not able to increase the extent size , next size beyond a > > particular level even if specify more number > > > > what to do? > > example > > create table test (with 200 columns ) extent size 3902 next size> > 1858692 > > > > > > what to check? > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > With what extent sizes is the table being created ? > You are asking for an initial extent of 3.9 Mb and a next extent of > 1.85 Gb?? Seems to be the wrong way round!! Do you have the contiguous > free space available for extents of this size?? How wide is the table > and how many rows are you loading? > > Keith _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list