Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Performance monitoring and the tools you useYou can use performance monitoring tools to create a performance history, to monitor database resources at scheduled times, or to monitor ongoing transaction or query performance.
Monitor database server resourcesMonitor specific database server resources to identify performance bottlenecks and potential trouble spots and to improve resource use and response time.
Monitor disk I/O utilizationYou can use some specific onstat -g arguments and the oncheck utility to determine if your disk I/O operations are efficient for your applications.
Using onstat -g to monitor I/O utilizationYou can use some specific onstat -g command arguments to monitor disk IO.

Using onstat -g to monitor I/O utilization

You can use some specific onstat -g command arguments to monitor disk IO.

Use the following onstat -g command arguments to monitor disk I/O utilization.


onstat -g Argument	Description
iof	Displays asynchronous I/O statistics by chunk or file This argument is similar to the onstat -d, except that information about nonchunk files also appears. This argument displays information about temporary dbspaces and sort files.
iog	Displays asynchronous I/O global information
ioq	Displays asynchronous I/O queuing statistics
iov	Displays asynchronous I/O statistics by virtual processor

For a detailed case study that uses various onstat outputs, see Case studies and examples.