Extents Monitoring
Hi, We are using IDS 11.50.FC3W1. I would like to know what is the correct method to identify the number of extents allocated/remaining for a particular table / index ? Does the page size effect the calculation for the extents ? Is there any relation between index and extents as well? DO we allocate any number (or default) of extents for index as well ? Regards Kasi
Detached indexes are their own partitions with their own independent extents, so that's not an issue. However, attached indexes are included in the table's own partition. In addition, the keys for attached indexes are recorded on that partition's header page and that reduces the space available to record extents. Yes, since the extent list has to be recorded on the partition header page, the page size will affect the maximum number of extents that a particular table can have. Doubling the pagesize roughly doubles the number of extents as well as doubling the amount of data that can be stored in those extents. The formula is detailed in the Performance Guide. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Nov 1, 2009 at 6:37 PM, SHAHZAD SALAM KASI <skasi@i2cinc.com> wrote: > Hi, > We are using IDS 11.50.FC3W1. > I would like to know what is the correct method to identify the number of > extents allocated/remaining for a particular table / index ? > > Does the page size effect the calculation for the extents ? > > Is there any relation between index and extents as well? > > DO we allocate any number (or default) of extents for index as well ? > > Regards > Kasi > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517476042561f5a04775b4d09