Re: Sizing question

Joe Trubisz schrieb: > > 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 Hi Joe, the following select (against sysmaster) should do what you want: select s.name dbspace, n.dbsname database, sum(ti_nptotal) total, sum(ti_npused) used, sum(ti_npdata) data, sum(ti_npused) - sum(ti_npdata) idx from systabinfo i,systabnames n, sysdbspaces s where i.ti_partnum = n.partnum and partdbsnum(i.ti_partnum)=s.dbsnum group by 1,2 order by 1,2 hth martin