Not able to insert rows becoze of extent size

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-20-2008, 12:11 PM

calyanram@hotmail.com

Posts: n/a

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

#2 (permalink)

04-20-2008, 12:11 PM

Keith Simmons

Posts: n/a

Re: Not able to insert rows becoze of extent size

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
>

#3 (permalink)

04-20-2008, 12:11 PM

=?iso-8859-1?q?Rich_or_Krist=EDn?=

Posts: n/a

Re: Not able to insert rows becoze of extent size

calyanram@hotmail.com wrote:
<snip>
> how to alter the extent size of the table?
<snip>

http://publib.boulder.ibm.com/infoce...s.doc/sqls.htm

#4 (permalink)

04-20-2008, 12:11 PM

tichman@excite.com

Posts: n/a

Re: Not able to insert rows becoze of extent size

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

#5 (permalink)

04-20-2008, 12:12 PM

Dimitar Bachvarov

Posts: n/a

Re: Not able to insert rows becoze of extent size

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
>
>
>
On IDS 7.3x I first reorg tables. for example:
alter fragment on table messages INIT IN datadbs;
(chek free space before !!!!)

and after that:
alter table messages MODIFY NEXT SIZE 48000;

Dimitar;

« Washington Area Informix Users Group - Forum 2006 - A User Conferenceby Users | SAN and dbspace layout. »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 05:20 AM.

SEO

Not able to insert rows becoze of extent size