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