Re: Temp dbspaces problem

Juan R. Guzman wrote: } = } Val=E9ry 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 onlin= e } > 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 } > =3D(_ _)=3D 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. One of our customer has the same problem. We sent this to Informix UK. Yesterday they replied that one as "this is a known problem and there is patch for it" . We will see what would happen... So, at this point, I would suggest you to try to connect Informix again... Bye... -- = Ozlem Atmaca Tel: +90 216 3275003 Technical Support Engineer Fax: +90 216 3264882 Login Bilgisayar A.S Istanbul/Turkey