RE: extent problem

>hey all: > Trying to load a table, having the following problem: > 271: Could not insert new row into the table. 136: ISAM error: no>more extents You have run out of extents for that table > 847: Error in load file line 59770.This is how far you got > hmm, what does this mean? and how can I fix it? I don't even remeber Reorganise the table with the correct extent information >setting up extents when I create the tables. You should have set up extents! >I checked the dbspace, plenty left, how could it run out? You have run out of extents for that table. > running 7.23 on solaris 7.0. > thanks a lot guys. >yan

That guy must work for microsoft - what he said was true, but completely unhelpful..... You can specify the first extent size and subsequent extent size in the create table statement (it's pretty simple - see manual for syntax).You can also find some info about calculating extent sizes somewhere in the manuals also. I'm at a loss to explain why there are no more extents.....perhaps there is not enough contiguous disk space to create a new one? perhaps there is an upper limit on extents and you have reached it? (Though I expect approaching this limit would have caused performance problems long ago). When things are working right, Informix allocates new extents as needed. If this table has been around forever, it's possible that there is alot of space allocated to the table that is not even being used. I would drop and recreate the table after spending a few minutes figuring out how much space I needed (both currently and in the long term). Hope this helps....BTW, Informix does have some of the manuals on their web site. Danny #include <stddisclaimers.h> /* I am not a DBA, nor have I read any books - anonymous quote */