Re: Database disk usage

Jeff Welsch wrote: > I think this was answered in recent weeks, but I did not hold on to the > response: > > How can I figure out the disk usage of my database? I am examining > migrating towards a new HP, and am trying to figure out the size of my > databases for the migration. Depends on how specific you want the disk usage. Size of chunks: onstat -d (sysmaster:syschkext) Allocated space in chunks: onstat -d Allocated extents in chunks: oncheck -pe (sysmaster:systabinfo) Used space in extents: oncheck -pT How much space you would need if you were to rebuild all the tables so there were no empty slots: use sysmaster:systabinfo.ti_nrows & ti_rowsize to calculate how many data pages you would need, add in index size (I think this is in the manual, also in a program somewhere), don't forget to do your system catalogs and tblspace tblspace pages...... This is not a comprehensive list of ways to obtain the information -- just the ones I know. Did you check the FAQ? http://www.iiug.org/techinfo/faq/faq_top.html June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plain)