Oninit cdi / Archive
Talk to an expert →

Re: Not able to increase the extent size?

Posted in 2006

Summary

calyanram reported that tables created with a large extent size and next size ended up with smaller extents, with no error shown. indikaj asked for the error; the poster said there was none but could not load more data. Another poster told him to check the manuals. No answer in the thread.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management

indikaj — — source: Usenet: comp.databases.informix

calyanram@hotmail.com wrote: > I am not able to increase the extent size , next size beyond a > particular > level even if specify more number > > what to do? > example > create table test (with 200 columns ) extent size 3902 next size> 1858692 > > > what to check?

↪ replying to indikaj
indikaj — — source: Usenet: comp.databases.informix

indikaj wrote: > calyanram@hotmail.com wrote: > > I am not able to increase the extent size , next size beyond a > > particular > > level even if specify more number > > > > what to do? > > example > > create table test (with 200 columns ) extent size 3902 next size> > 1858692 > > > > > > what to check? What's the error you hit when you do the task ?

↪ replying to indikaj
calyanram@hotmail.com — — source: Usenet: comp.databases.informix

there is no error but the table is created with the extents which is less than what i specify in create table command with the extents we cannot load more data what we are having at present? so what is the reason that table is not created with the extents what i specify? regards indikaj wrote: > indikaj wrote: > > calyanram@hotmail.com wrote: > > > I am not able to increase the extent size , next size beyond a > > > particular > > > level even if specify more number > > > > > > what to do? > > > example > > > create table test (with 200 columns ) extent size 3902 next size> > > 1858692 > > > > > > > > > what to check? > > What's the error you hit when you do the task ?

↪ replying to calyanram@hotmail.com
=?iso-8859-1?q?Rich_or_Krist=EDn?= — — source: Usenet: comp.databases.informix

calyanram@hotmail.com wrote: <snip> > so what is the reason that table is not created with the extents > what i specify? <snip> Have you checked what your attempting to do against the information supplied in the manuals ? They're available online, here's a starting point for you: http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.admin.doc/admin340.htm HTH