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 CPU utilizationThe combination of operating-system and HCL OneDB™ configuration parameters can affect CPU utilization. You can change the settings of the HCL OneDB™ configuration parameters that directly affect CPU utilization, and you can adjust the settings for different types of workloads.
Virtual processors and CPU utilizationWhile the database server is online, you can start and stop virtual processors (VPs) that belong to certain classes.
Monitoring virtual processorsMonitor the virtual processors to determine if the number of virtual processors configured for the database server is optimal for the current level of activity.

Monitoring virtual processors

Monitor the virtual processors to determine if the number of virtual processors configured for the database server is optimal for the current level of activity.

To monitor virtual processors:

Use command-line utilities, such as onstat-g ioq to view information. See Using some onstat-g commands to monitor virtual processors
Use the AUTO_AIOVPS configuration parameter to enable the database server to automatically increase the number of AIO virtual processors and page-cleaner threads when the server detects that AIO virtual processors are not keeping up with the I/O workload.
Query SMI tables. See Using SMI tables to monitor virtual processors.