How do I explore performance information?
- Analyzing query performance with SQL Explorer
- Optimizing SQL statements
Create an external directive to optimize an SQL statement by using the HCL OpenAdmin Tool (OAT) for Informix. - Exploring user sessions
- Viewing performance history
View historical data on profiled fields, including auto checkpoints, disk and buffer activity, memory, virtual processors, and the B-tree scanner. - Running system performance reports
Create system performance reports based on current data and historical data. - Monitoring extents
View a graph of the number of extents in the databases on the current database server. - Monitoring the buffer pool
View a graph of the percentage of cached pages in the buffer pool for the databases on the current database server. - Monitoring servers with the onstat utility
Display performance and status information for a database server by using the onstat utility in the HCL OpenAdmin Tool (OAT) for Informix.
Parent topic: HCL OpenAdmin Tool (OAT) for Informix