RE: tablespace:tablespace`

You probably can't drop the dbspaces because they are in DBSPACETEMP so considered used. If you pull them out of DBSPACETEMP and bounce the engine you should be able to drop the temp dbspaces then re-add them (maybe doing a level 0 do /dev/null in the middle). I am assuming no programs are running with environment variables setting the temp dbspaces for it. I would think rebuilding the chunks from the system level would cause quite a bit of pain. Hope this helps Will >===== Original Message From Bridget Reitsma <b.reitsma@auckland.ac.nz> ===== >Hi > >I have a problem, when I run an oncheck -pe it reports a lot of >tablespace:tablespace in my temp space. I am also getting errors that >there is not enough contigious space to do sorts. So in an attempt fix >this I am going to do the following: > > * Create new temporary chunks and dbspaces. > * Change the DBSPACETEMP in the onconfig (get rid of currnet ones > replace with new ones) > * Restart the engine > * I would then like to drop the old dbspaces - but this is impossible > as it thinks there is still data in it. > * So I will rebuild the chunks from system level (will this cause any > problems - ie wiping the chunk but still having the dbspace listed > in the sytem?) > * Recreate old tempspaces as dbspaces etc and add them back in. > >My main concern is that when I rehash the chunks from the OS level it >will stuff up soemthing at the infomrix level. Will informix think that >dbspace exists even if I drop the chunk at OS level. Any better ways to >do this? Is this tablespace:tablespace a bug? > >thanks a lot >Bridget ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------