Re: Couldn't drop dbspace

Hi Ivan!! First of all: before use what I am going to tell you be sure that it is at your own risk. Read it and you'll know why. I have had the same problem several times and what I finally did was to drop the file where the dbspace reside fisically. Then the next time you start Informix online it says that can not find the file for the dbspace but after that you should be able to drop that dbspace whit no problem. I am using standard unix files, so I don't know if it will work with raw files. What I have here is AIX 4.1.5 whit IBM J40 and Informix On-Line 7.13 Good luck! Ivan Lyakhovenko escribi': > Hi Gurus! > > 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? > > Any advises will be appreciated. > Thank you in advance. > > -- > Ivan Lyakhovenko, project manager, xTech Ltd. > Novosibirsk, Russia. > mailto:van@xTech.ru > http://www.xTech.ru