Re: Sizing question

In article <6d6q3f$nt6@newsserv.cs.sunysb.edu>, trubisz@cs.sunysb.edu (Joe Trubisz) wrote: > > Hi.. > > I currently have a development database w/data and > index space sharing the same tablespace. I'm moving > it to a new non-development machine and I want to split > up the base and index spaces. > > Is there a way I can calculate how much space has > been allocated to just the tables in the tablespace? > > Thanks, > Joe Yup ... Assuming page size of 2k (check your ONLINEDOC_xxx in $INFORMIXDIR/release/en_us/<some_number>) 1) For each table, divide its row length into 2016 (i.e. 2048 - header info). 2) The nearest integer BELOW the result is the number of rows per page (the rest of the space is lost/unused). 3) Divide (number of rows in the table) by (number of rows per page) for that table. 4) Take the nearest integer ABOVE the result to get the number of pages used by that table. 5) Multiply (number of pages used) by (page size) to get data space used by the table with the current data. Of course, you will have set initial and next extent sizes to allow for initial table fill + a goodly period of growth ... THAT'S ALL THERE IS TO IT! -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading