Re: Extent size limit

On Jun 13, 3:28 am, scottishpoet <drybur...@yahoo.com> wrote: > On Jun 13, 1:14 am, Octavio Gomez <sogo...@hotmail.com> wrote:> Sorry, but my initial question is still on air. > > What will happen next time the engine try to increase the extent size? > > > I understand can happen 3 diferents scenarios: > > > It will stay at same size, > > It will adjust to chunk size (512,000 pages, or available space in chunk) or > > It will oversize chunk and create an error situation (after read your comments I can be sure this will not happen) > > octavio, > > extent doubling does not occur every time the engine allocates an > extent > > Extent size doubling is allowed only if the total number of pages > allocated so far is at least 16 times the current next extent size. > This is a precautionary measure to limit the exponential doubling of > next extent size,. Extent doubling happens every 32 extents. When the number of extents reaches 32, 64, 96, etc. the engine doubles the NEXT SIZE. of the table. Art S. Kagel > What is your NEXT EXTENT size set to? (select nextsize from systables > where tabname = "<the name of your table>" > > An extent is always entirely contained in a chunk; an extent cannot > cross chunk boundaries. > If the database server cannot find the contiguous disk space that is > specified for the next-extent size, it searches the next chunk in the > dbspace for contiguous space. > > If it can't space of an appropiate size it may give an out of space > error > > http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.ad...