Re: informix Turbo problems

aim1user@shakti.ncst.ernet.in (CITIL ) writes: |> We are using informix Turbu version 1.1 with modificaton from Plexus |> for image support We are facing a lot of problems with the configuration |> that we have We would like to have any information about the following |> configuration |> We have a HP 9000 842 machine with a Juke box for optical storage. The |> machine has a hot standby (switchove unix ) and disk mirrors . We have |> the database size of 1.3 GB and images of 20 GB. |> The informix database gives the following problems |> 1. The engine does not delete the temp. tables created during join |> orderby operations. This is a known Turbo bug. As Turbo is an ooooolllllldddddd product, replaced by OnLine back in 1989, I suppose the only fix is to upgrade to OnLine and use the OnLine/Optical product for your image support. |> 2. The database does not give any information on access path of a query Turbo did not provide set explain functionality. For that matter, it didn't even have a cost-based optimizer (it was rule-based). Again, time to upgrade. |> 3. The database goes into a semaphore wait once a day I'm not familiar with this problem offhand, but again I suspect a Turbo bug. Upgrade upgrade upgrade. |> 4. Index degradation is to often and degradation of performance is large |> no way to check the usability of the index. I'm sounding like a broken record, but again, upgrade. There was no tbcheck in Turbo, and there were some problems with indexes on sequential data that is deleted (empty btree nodes were not freed up for general reuse). |> |> If anybody has an idea please contact If it hasn't yet been made clear: upgrade to OnLine. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney