ROWIDs and fragmented temporary tables
Posted in 1999
Hello, I have a question regarding ROWIDs on fragmented temporary tables. I've just installed and configured an Informix server (7.30) and I configured it to use three temporary dbspace. I've got a surprise discovering that some of applications use rowid columns on temporary tables. As a result of using more than one temporary dbspaces the temporary tables got fragmented and these applications end up with an error stating that there are no rowids on fragmented tables. Is there any ways to handle this issue quickly (Informix Server parameter on env. variable) ? Of course for now I've listed just one temporary dbspace in DBSPACETEMP onconfig parameter and if we'll have to we'll rewrite the application so it will not use rowid's on temporary tables, but I'm wondering wether it is a simpler sollution. Thank you, Octav Sent via Deja.com http://www.deja.com/ Before you buy.