Re: tbstat -d question

Zeljan Silje wrote: > > Hi, > > I was deleting large amount of unnecessary data from my database. I use > sql command: delete from table ... After deletion tbstat -d doesn't show > me any change in free pages. > I archive and restarted informix, but there was no change. > When I drop table, tbstat -d show me a change in free pages. > I am using OnLine5.0x on SCO unix. > > Any idea? > > Thanks in advance. > Once an Informix table allocates a page, it will not deallocate the page. The only way to reuse freed pages due to deletions is to dump the data, then drop and recreate the table and reload the data. That's why tbstat -d shows the changes in free pages after you drop / recreate the table and not before. John Carlson Informix DBA WH Smith, Inc.