RE: Dropping dbpace in ODS 7.2

Posted in 2000

Murray Wood — Tue, 25 Jul 2000 09:51:07 +1200 — source: Informix-list mailing list archive (1991-1998)

You need to get Informix Support to drop it for you. (A bug fixed in later versions). MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Graeme Muirhead Sent: Tuesday, July 25, 2000 8:35 AM To: informix-list@iiug.org Subject: Dropping dbpace in ODS 7.2 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