Monitoring Data Buffers (Informix)
Use
You can use the SAP/Informix database monitor to monitor Informix data buffers.
Tuning buffers makes accesses to memory much faster than those to disk. The basic rule when tuning buffers is to keep increasing the buffers until new increases provide no improvement in performance. However, avoid significantly increasing the operating system paging.
For up-to-date recommendations on data buffers, see SAP Note 38307.
Procedure
Choose Tools
® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity to see the display for Data Buffers (Informix) on the main screen of the database monitor.
See also:
BUFFERS (Informix)