My customer is running Informix Online 7.23 UC9 on UnixWare 2.1.3. They have one temp dbspace defined in the onconfig file. That temp dbspace is now filled up with temp tables that we can't get rid of. I have tried to drop the dbspace with the intention to rebuild it but onspaces says 'dbspace not empty'. I also tried to drop some of the tables in that dbspace without any success. So as a temporary solution i created a new temporary dbspace and modified onconfig to use it. It will fill up like the old one sooner or later.
Anyone who have a clue here ?