Performance guide for IBM Informix Dynamic Server Version 10.0 covering measurement, monitoring, configuration, I/O, tables, indexes, locking, and…
This guide explains how to measure and tune the performance of IBM Informix Dynamic Server Version 10.0. It covers performance goals, throughput, response time, cost per transaction, and resource utilization for CPU, memory, and disk.
The guide also explains how configuration parameters and environment variables affect CPU, memory, and I/O activity, and provides guidance on table placement, index design, locking, fragmentation, and query optimizer behavior. Monitoring utilities and methods described include onstat, onlog, ISA, SMI tables, and SET EXPLAIN.
| Product version | Version 10.0 |
|---|---|
| Document number | G251-2296-00 |
| First edition date | December 2004 |
It covers IBM Informix Dynamic Server Version 10.0.
It covers IBM Informix Dynamic Server Version 10.0.
It describes performance measurement and tuning.