tbstat -d question
Posted in 1998
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 | +--------------------------+-----------------------------+