Re: Help calculating extents from esql-c

OK keemosabee what does this do, sounds very interesting. does it actually modify the initial extent or move the table to a temp and create a new one with the proper extents or like what ?? Thanks CRAIG@CHEMISTRY.CHEM.UTAH.EDU wrote: >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.?? >}