About This Manual

This manual provides information about how to configure and operate IBM Informix Dynamic Server to improve overall system throughput and to improve the performance of SQL queries. The manual includes information on performance tuning issues and methods that are relevant to daily database server administration and query execution. Performance measurement and tuning encompass a broad area of research and practice and can involve information beyond the scope of this manual.

Information in this manual can help you perform the following tasks:

• Monitor system resources that are critical to performance
• Identify database activities that affect these critical resources
• Identify and monitor queries that are critical to performance
• Use the database server utilities (especially onperf, ISA and onstat) for performance monitoring and tuning
• Eliminate performance bottlenecks by:
  • Balancing the load on system resources
  • Adjusting the configuration parameters or environment variables of your database server
  • Adjusting the arrangement of your data
  • Allocating resources for decision-support queries
  • Creating indexes to speed up retrieval of your data

In addition, this manual contains the full description of the onperf utility.