Re: Dropping dbpace in ODS 7.2

Posted in 2000

Art S. Kagel — Mon, 24 Jul 2000 17:39:12 -0400 — source: Informix-list mailing list archive (1991-1998)

Was this part of a TEMP dbspace? If so temp tables are not always dropped physically until the engine is shutdown and restarted. Also there are a few versions with bugs that will NEVER clean up SOME temp tables, but you did not post your exact version and platform. Art S. Kagel Graeme Muirhead wrote: > > When I try to drop the chunks in an unused dbspace Informix tells me they > are not empty. Oncheck -pe outputs this: > > FREE 5443 1504 > TBLSPACE TBLSPACE 6947 50 > FREE 6997 1536 > TBLSPACE TBLSPACE 8533 50 > FREE 8583 1672 > TBLSPACE TBLSPACE 10255 50 > FREE 10305 1648 > TBLSPACE TBLSPACE 11953 50 > FREE 12003 1664 > TBLSPACE TBLSPACE 13667 50 > FREE 13717 1856 > TBLSPACE TBLSPACE 15573 50 > FREE 15623 1568 > TBLSPACE TBLSPACE 17191 50 > FREE 17241 1632 > TBLSPACE TBLSPACE 18873 50 > FREE 18923 1632 > TBLSPACE TBLSPACE 20555 100 > FREE 20655 3008 > TBLSPACE TBLSPACE 23663 100 > FREE 23763 3360 > TBLSPACE TBLSPACE 27123 100 > FREE 27223 3200 > TBLSPACE TBLSPACE 30423 100 > FREE 30523 3200 > TBLSPACE TBLSPACE 33723 100 > FREE > > What can I do to empty the chunk? > > Thanks > > Graeme Muirhead > g_muirhead@csisystems.co.uk