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.
Effect of configuration on I/O activityThe configuration of your database server affects I/O activity.

Effect of configuration on I/O activity

The configuration of your database server affects I/O activity.

The following factors affect I/O activity:

The assignment of chunks and dbspaces can create I/O hot spots, or disk partitions with a disproportionate amount of I/O activity.
Your allocation of critical data, sort areas, and areas for temporary files and index builds can place intermittent loads on various disks.
How you configure read-ahead can increase the effectiveness of individual I/O operations.
How you configure the background I/O tasks, such as logging and page cleaning, can affect I/O throughput.