there is no error but the table is created with the extents which is
less
than what i specify in create table command

with the extents we cannot load more data what we are having
at present?

so what is the reason that table is not created with the extents
what i specify?

regards

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:

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list