Re: Can only allocate 4 extents
On 12 Mar, 08:39, skurlan...@yahoo.com wrote:
> Informix 11.10.UC2 running on linux is reporting an error "Could not
> insert new row into the table. ISAM error: no more extents". onstat
> -T shows that for this table I've allocated 4 extents; 212,227,546
> rows; 16,777,215 pages have been allocated (each page is 2K);
> 16,777,215 pages have been used.
>
> The table has both an extent size and a next extent size of 10,485,760
> K. onstat -d shows we have 8 free chunks each of 10,485,760 K.
>
> I don't understand why there are no more extents.
>
> Thanks for any help.
>
> SteveKurlander
Thanks for your help. I've fragmented the table and am able to load
all the data into the db.