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.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Virtual processors and threadsThese topics describe virtual processors, explain how threads run within the virtual processors, and explain how the database server uses virtual processors and threads to improve performance.
Virtual processorsA virtual processor is a process that the operating system schedules for processing.
Advantages of virtual processorsA virtual processor provides a number of advantages.
Parallel processingWhen a client initiates index building, sorting, or logical recovery, the database server creates multiple threads to work on the task in parallel, using as much of the computer resources as possible. While one thread is waiting for I/O, another can be working.

Parallel processing

When a client initiates index building, sorting, or logical recovery, the database server creates multiple threads to work on the task in parallel, using as much of the computer resources as possible. While one thread is waiting for I/O, another can be working.

In the following cases, virtual processors of the CPU class can run multiple session threads, working in parallel, for a single client:

Index building
Sorting
Recovery
Scanning
Joining
Aggregation
Grouping
User-defined-routine (UDR) execution

For more information about parallel UDR execution, see HCL OneDB™ User-Defined Routines and Data Types Developer's Guide.

The following figure illustrates parallel processing.

The paragraph that precedes this figure describes the content of the figure. — Figure 1: Parallel processing

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.