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.
Background I/O activitiesBackground I/O activities do not service SQL requests directly. Many of these activities are essential to maintain database consistency and other aspects of database server operation. However, they create overhead in the CPU and take up I/O bandwidth.
Configuration parameters that affect page cleaningSeveral configuration parameters, including the CLEANERS and RTO_SERVER_RESTART configuration parameters, affect page cleaning. If pages are not cleaned often enough, an sqlexec thread that performs a query might be unable to find the available pages that it needs.
RTO_SERVER_RESTART and its effect on page cleaningThe RTO_SERVER_RESTART configuration parameter allows you to use recovery time objective (RTO) standards to set the amount of time, in seconds, that OneDB has to recover from a problem after you restart OneDB and bring it into online or quiescent mode.

RTO_SERVER_RESTART and its effect on page cleaning

The RTO_SERVER_RESTART configuration parameter allows you to use recovery time objective (RTO) standards to set the amount of time, in seconds, that OneDB has to recover from a problem after you restart OneDB and bring it into online or quiescent mode.

When this configuration parameter is enabled, the database server automatically adjusts the number of AIO virtual processors and cleaner threads and automatically tunes LRU flushing.

Use the AUTO_LRU_TUNING configuration parameter to specify whether automatic LRU tuning is enabled or disabled when the server starts.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.