RE: identify free space

The sysmaster database might provide limited information: select nptotal, npused, npdata ,nrows from systabnames tab, sysptnhdr hdr where tab.partnum = hdr.partnum and tab.dbsname = '<database name>' and tab.tabname = '<table name>' The value 'npused' will correspond to the "Number of pages used" column of the oncheck -pt command. 'Npdata' corresponds to the number of data pages used, which will change depending on inserts and deletes. However, it does not take index storage into account and so does not appear to be a very good indicator of tracking purged data. Unload / reload is the most reliable means to me. John Carlson Informix Database Administrator EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 -----Original Message----- From: Tham Huei Hwan [mailto:hhtham@apis.dhl.com] Sent: Tuesday, January 16, 2001 3:45 AM To: informix-list Subject: identify free space 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

In article <941s29$lh8$1@news.xmission.com>, John Carlson <John_Carlson@whsmithusa.com> writes > >The sysmaster database might provide limited information: > >select nptotal, npused, npdata ,nrows >from systabnames tab, sysptnhdr hdr >where tab.partnum = hdr.partnum > and tab.dbsname = '<database name>' > and tab.tabname = '<table name>'> oncheck -pT database:table >The value 'npused' will correspond to the "Number of pages used" column of >the oncheck -pt command. 'Npdata' corresponds to the number of data pages >used, which will change depending on inserts and deletes. However, it does >not take index storage into account and so does not appear to be a very good >indicator of tracking purged data. > >Unload / reload is the most reliable means to me. > >John Carlson >Informix Database Administrator >EDS - WHSmith USA >3200 Windy Hill Road, Suite 1500 West >Atlanta, GA 30330 > > > > >-----Original Message----- >From: Tham Huei Hwan [mailto:hhtham@apis.dhl.com] >Sent: Tuesday, January 16, 2001 3:45 AM >To: informix-list >Subject: identify free space > > >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 -- David Williams