Re: Help calculating extents from esql-c

Randy, Why not just use "alter index to cluster" and "alter index to not cluster" to fix your extents automagically? If you must, the sizes can be calculated although it's a pain to do it right. (Right meaning calculating the index sizes + overhead, data sizes + overhead, table overhead, etc.) --Craig (craig@chemistry.utah.edu) } } Hello, } } I need to calculate the extent size of a table on the fly. } } The table exists in the database, I want to calculate the } } correct extent (not use the values in systable for extent) } } then drop the table and re_create the table with the new extent } sizes. } } I found a shell script in a FAQ on the web , but it depends on } a tbcheck and pulls out the "number of pages used." } } Does someone have the formula.?? }