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 We just had the same problem with Online 7.22.UC2 on Solaris 2.5.1. Unfortunately, we could not find anything to free up this temp space. Informix tech support had to perform some 'magic' in order for the space to be freed so that we coud drop the temp dbspaces. I was informed that this happens every now and then. Good luck... cpk