Informix Tuning Tips

Informix Tuning Tips

Your Informix Database has been slowed down during the past months? Response times have increased? Users have to wait?

Because of this you are going to purchase more powerful computers? Or another Informix Edition/Version? Stop! Most likely you only need to optimize your Informix database! And tuning Informix is cheaper and faster than buying new Hard- /Software!

In the following some general recommendations:

  • Use indices
  • Avoid Sequential Scans
  • Think about Hyper Threads or SMT Threads
  • Extend your bufferpool
  • Check the SHMVIRT segment
  • Take care of enough Locks
  • Configure Temp Dbspaces
  • Optimize Disk IO (LRU, KAIO, Direct IO)
  • Use CPUVPs
  • Don’t forget Updata Statistics


Despite of these tips: you have to test, test, test … - and this takes some time – because too different are datatypes and structures, data volumes and requests.

If you do not like to analyze, optimize and test  on your own, contact hamburg data. We have been working for more than 20 years with Informix. We overtake the job, check the status quo, coordinate the planed status together with you and trim your Informix database for the future – structured, quick and worth the money.

  • hamburg data GbR
  • Jörg Kleinitzke & Oliver Hesse
  • Oehleckerring 4
  • 22419 Hamburg

loation and how to find us  How to find us

  • Tel.:+49 (0)40 875 00 589
  • Fax.:+49 (0)40 875 01 968
  • eMail: This email address is being protected from spambots. You need JavaScript enabled to view it.
  • VAT.-Id.-No.: DE277820876
  • Taxl office: Hamburg Nord