Not able to insert rows becoze of extent size
S. Kalyan could not insert rows despite free dbspace space and asked how to change the table's extent size. Keith Simmons asked for version, platform and table details and whether the maximum number of extents was hit. Another poster pointed to the manual. tichman said a reorg is needed, e.g. building a raw table with proper extents, loading and renaming, and supplied a query on systabnames and sysptnext to size extents.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I am not able to add rows even though space is available in dbspace. how to alter the extent size of the table? shall i need to reorg or is there any way to do? regards s.kalyan
What Version, what platform, what O/S ??? How wide is the table, how deep is the table ?? Ca you delete ay rows fom the table? Can you detach an index? You may not have exceeded he max numberof extents, it may be more serious than that !! On 3 Oct 2006 02:51:28 -0700, calyanram@hotmail.com <calyanram@hotmail.com> wrote: > I am not able to add rows even though space is available in dbspace. > > > how to alter the extent size of the table? > > shall i need to reorg or is there any way to do? > > regards > s.kalyan > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
calyanram@hotmail.com wrote: <snip> > how to alter the extent size of the table? <snip> http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls.htm
Hi,
you will need to reorg. depending on your version you could reduce
downtime by creating a raw table with the appropriate extents, load the
data and rename the tables accordingly. Below is a script that can help
calculate the extents required.
select dbsname,tabname ,
count(*) num_of_extents,
sum (pe_size) current_pages_used,
round (sum(pe_size) * 2 * 1.2) proposed_ext_size,round (sum(pe_size) * 2 * 0.2) proposed_next_size
from systabnames,sysptnext
where partnum= pe_partnum
group by 1,2
order by 3 desc,4 desc
calyanram@hotmail.com wrote:
> I am not able to add rows even though space is available in dbspace.
>
>
> how to alter the extent size of the table?
>
> shall i need to reorg or is there any way to do?
>
> regards
> s.kalyan