Re: Extent/Next Extent

david.ashby@workcover.nsw.gov.au wrote: : Greg, : : More info next time please. : : If the table is already allocated and you want to know the current : allocations just do a "dbschema -d dbname -t tabname -ss" this will : give you the current sizes. Warning the extents are in kbytes not : pages. : : If you are planning on creating a table. Work out the expected size : add some room for growth (I usually add 20%) and specify this as your : extent size in kbytes. I usually do a next size of 20% of the primary : allocation. : Check out www.wilsontechnology.com under 'Resources' for Informix scripts to do this. -- Bruce Momjian | 830 Blythe Avenue root@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)