Re: Couldn't drop dbspace

Hi Ivan, verify in the output of "oncheck -pe" the chunk entries of the mentioned dbspace. If the dbspace is really empty only reserved, chunk free list and TBLSPACE TBLSPACE pages should reside in the dbspace. If this is true the only way you have is to reorganize your complete db (dbxport, oninit -i, dbimport) or contact the Ifmx hotline (for patching). Hope this helps Uwe -- Xerox your life - If you'll loose it, it's nice to have a copy Uwe Feuerstein iXOS Anwendungssoftware GmbH Leipzig, Germany Ivan Lyakhovenko wrote: ... > I've got a very strange problem: > I'm using OnLine 7.10UC1 in SCO3.2.v4.2. > When I'm trying to drop a non-root dbspace, Informix says that this dbspace > is not empty. Onstat -d says that this dbspace really has non-empty pages (a > lot of pages!!!). BUT I'm sure, that there are NO databases and tables on > this space. What happen? How could I clean up this space or how could I drop > non-empty dbspace? ...