136: ISAM error: no more extents
IBM Informix Dynamic Server Version 11.50.FC6
while doing following ALTER TABLE ec_archived_cert
ADD template_reference varchar(20,0);
I got following message
222: Cannot write to temporary file for new table (paqis.ec_archived_cert).
136: ISAM error: no more extents
Error in line 32Near character position 40
MY questiion is has it actually run out of extents or disk space.If disk space
is it temp dbspace or space where table resides - dataspc5
THis job ran overnight so I was not able to watch available space
there are 17 extents in table.
I am reloading database to try again .
Try increasing the NEXT SIZE of the table before trying the ALTER.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Mar 14, 2012 at 3:09 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote:
> IBM Informix Dynamic Server Version 11.50.FC6
>
> while doing following ALTER TABLE ec_archived_cert
>
> ADD template_reference varchar(20,0);
>
> I got following message
>
> 222: Cannot write to temporary file for new table (paqis.ec_archived_cert).>
> 136: ISAM error: no more extents
> Error in line 32> Near character position 40
>
> MY questiion is has it actually run out of extents or disk space.If disk
> space
> is it temp dbspace or space where table resides - dataspc5
> THis job ran overnight so I was not able to watch available space
> there are 17 extents in table.
> I am reloading database to try again .
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba9314bc58004bb38c6ea
iT was actually the dbsapce short of space. So message was a bit misleading