Re: identify free space

I would join sysmaster:sysptnhdr to sysmaster:systabnames and use nptotal-npused from sysptnhdr. Hope this helps, Will P.S. as always I make the assumption the sysmaster of the version you work on is the same as the one I work on. I have found a couple occasions where this is incorrect. In article <9413ep$dti$1@news.xmission.com>, Tham Huei Hwan <hhtham@apis.dhl.com> wrote: > > hi all, > > I would like to know how to find out the free space on dbspaces after > the data purging ? Because this doesn't show on "onstat -d" and "oncheck > -pe". > > Others than rebuild table (load/unload) and alter index to cluster to > free up the space (very time consuming for large tables). Is there any > other command to check free space on chunks/dbspaces ? > > Thanks and regards, > > Tham > > Sent via Deja.com http://www.deja.com/