Re: tbstat -d question

You won't see space given back since once extents are allocated they are not given back unless you drop the table (which you have tried). -Bill 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. > > +--------------------------------------------------------+ > | CC Computer Consulting d.o.o. | > +--------------------------+-----------------------------+ > | Zeljan Silje | e-mail: zeljan@laus.hr | > | CC Computer Consulting | Tel: +385 (20) 411-136 | > | Janjevska 15 | +385 (1) 6552-330 | > | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | > | Hrvatska (Croatia) | URL: http://www.laus.hr | > +--------------------------+-----------------------------+