informix Turbo problems

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. 2. The database does not give any information on access path of a query 3. The database goes into a semaphore wait once a day 4. Index degradation is to often and degradation of performance is large no way to check the usability of the index. If anybody has an idea please contact aim1user@shakti.ncst.ernet.in Address Citicorp Information Technology Industries Lt. C-117, St Andrews Road, Bandra West, Bombay 400 050 India Fax : 91-22-6436586 Tel : 91-22-6436308