Re: Temp dbspaces problem

Val'ry wrote: > > Hi, we are running Online 7.22.UC1 on HP9000 10.01. > We have three temp dbspaces of 400Mo each. > We discovered that not all the temporary tables were dropped at online > initialization. > We didn't see the loss of space before, because there was only small temp > tables locked inside the dbspaces, but now we have 1Go (one gigabyte) > wasted space. > Bringing online down and up doesn't free the space. > We can't even drop the chunks (not empty :-( ) > > Some ideas, fixes, patches, anything that can help ??????? > -- > Valery Fouques valou@hotmail.com > SYSADM GOSPORT-FRANCE /\\oO/\\ > > _ __/| > \\`O.o' "355/113 -- Not the famous irrational > =(_ _)= number PI, but an incredible simulation!" > U I'm having the same problem under online 7.22UC2 with Sparc solaris 2.5.1. Informix hasn't given me an answer yet (they've been working on it for 3 days now). Somebody wrote to me saying that informix dialed into their machine and cleared the temp space. Sounds like a bad idea to me having informix dial-in to your machine every so often. I discovered that if you do an archive (ontape -s -l 0) and then restore it it clears it up. Either way is unaccpetable to me. You would think that Informix would have better testing before putting it out. After all this is a basic "feature" that is easily tested.