Re: Not able to increase the extent size?

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?

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 ?

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 ?

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