Not able to insert rows becoze of extent size

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