Jump to main content
HCL Logo Product Documentation
  • Customer Support
HCL OneDB 2.0.1
  • What's new in HCL OneDB™ 2.0.1
  • Getting Started
  • Installing
  • Administering
  • Migrating and upgrading
  • Data warehousing
  • Security
  • Client APIs and tools
  • SQL programming
  • JSON compatibility
  • Extending HCL OneDB™
  • Designing databases
  • Embedding HCL OneDB™
  • Release information
  • Troubleshooting HCL OneDB™
  1. Home
  2. AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
  3. 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.
  4. Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
  5. Disk, memory, and process management
  6. 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.
  7. Virtual processor classesEach class of virtual processor is dedicated to processing certain types of threads.
  8. CPU virtual processorsThe CPU virtual processor runs all session threads (the threads that process requests from SQL client applications) and some internal threads.
  9. Add and drop CPU virtual processors in online modeYou can add or drop CPU class virtual processors while the database server is online.
  • 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™.
        • The database server
        • 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.
            • How virtual processors service threadsA virtual processor services multiple threads concurrently by switching between them.
            • Virtual processor classesEach class of virtual processor is dedicated to processing certain types of threads.
              • CPU virtual processorsThe CPU virtual processor runs all session threads (the threads that process requests from SQL client applications) and some internal threads.
                • Determine the number of CPU virtual processors neededThe right number of CPU virtual processors is the number at which they are all kept busy but not so busy that they cannot keep pace with incoming requests. You must not allocate more CPU virtual processors than the number of hardware processors in the computer.
                • Run on a multiprocessor computerIf you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the onconfig file to 1.
                • Run on a single-processor computerIf you are running the database server on a single-processor computer, set the MULTIPROCESSOR configuration parameter to 0. To run the database server with only one CPU virtual processor, set the SINGLE_CPU_VP parameter to 1.
                • Add and drop CPU virtual processors in online modeYou can add or drop CPU class virtual processors while the database server is online.
                • Prevent priority agingSome operating systems lower the priority of long-running processes as they accumulate processing time, a feature of the operating system known as priority aging.
                • Processor affinityThe database server supports automatic binding of CPU virtual processors to processors on multiprocessor computers that support processor affinity.
              • User-defined classes of virtual processorsYou can define special classes of virtual processors to run user-defined routines or to run a DataBlade® module.
              • Tenant virtual processor classTenant virtual processor classes are specific to tenant databases. If you configure multitenancy for your HCL OneDB™ instance, you can specify that session threads for tenant databases are run in tenant virtual processors instead of CPU virtual processors.
              • Java™ virtual processorsJava™ UDRs and Java™ applications run on specialized virtual processors, called Java virtual processors (JVPs).
              • Disk I/O virtual processorsThe following classes of virtual processors perform disk I/O: PIO (physical-log I/O), LIO (logical-log I/O), AIO (asynchronous I/O), and CPU (kernel-asynchronous I/O).
              • Network virtual processorsA client can connect to the database server in the through following ways: a network connection, a pipe, or shared memory.
              • Audit virtual processorThe database server starts one virtual processor in the audit class (ADT) when you turn on audit mode by setting the ADTMODE parameter in the onconfig file to 1.
              • Miscellaneous virtual processorThe miscellaneous virtual processor services requests for system calls that might require a very large stack, such as fetching information about the current user or the host-system name.
              • Basic text search virtual processorsA basic text search virtual processor is required to run basic text search queries.
              • MQ messaging virtual processorAn MQ virtual processor is required to use MQ messaging.
              • XML virtual processorAn XML virtual processor is required to perform XML publishing.
          • Manage virtual processorsThese topics describe how to set the configuration parameters that affect database server virtual processors, and how to start and stop virtual processors.
          • Shared memoryThese topics describe the content of database server shared memory, the factors that determine the sizes of shared-memory areas, and how data moves into and out of shared memory.
          • Manage shared memory
          • Data storageThe database server uses physical units of storage to allocate disk space. It stores data in logical units. Unlike the logical units of storage whose size fluctuates, each of the physical units has a fixed or assigned size that is determined by the disk architecture.
          • Manage disk spaceYou can use several utilities and tools to manage disk spaces and the data that the database server controls.
          • Moving data with external tablesYou can use external tables to load and unload database data.
        • Logging and log administration
        • Fault tolerance
        • High availability and scalabilityA successful production environment requires database systems that are always available, with minimal if any planned outages, and that can be scaled quickly and easily as business requirements change.
        • Distributed data
        • Overview of automatic monitoring and corrective actionsYou can use the SQL administration API, the Scheduler, and drill-down queries to manage automatic maintenance, monitoring, and administrative tasks.
        • HCL OneDB server licensing
      • Administrator's ReferenceThe HCL OneDB™ Administrator's Reference includes comprehensive descriptions of HCL OneDB™ configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.
      • DB-Access User's GuideThis publication describes how to use the DB-Access utility to access, modify, and retrieve information from 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.
      • OneDB ExploreOneDB Explore is a modern web console for visualizing, monitoring, and managing your OneDB server instances. It is purpose built for ease-of-use, scaling out, and optimizing DevOps needs. It provides critical performance management capabilities, monitoring how key performance metrics are changing over time and tracking how efficiently OneDB is running your workload even when you’ve stepped away from your screen. Its monitoring system feeds directly into a customizable alerting system so you can be immediately alerted via email, Twilio, or PagerDuty whenever an issue occurs on one of your OneDB database server instances. OneDB Explore is designed to be scalable to efficiently manage and monitor as many OneDB database server instances as you need. Moreover, it's a tool that can be shared by the DBAs, the app developers, the ops engineers, and management and accessed from any desktop, laptop, or mobile device. OneDB Explore is the centralized hub for graphical monitoring, alerting, and administration of your OneDB database servers.
    • Backup and Restore GuideThe HCL OneDB™ Backup and Restore Guide describes how to use the HCL® OneDB® ON-Bar utility to back up and restore database server data. This will enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
    • Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.

Add and drop CPU virtual processors in online mode

You can add or drop CPU class virtual processors while the database server is online.

For instructions on how to add or drop CPU class virtual processors, see Add virtual processors in online mode and Drop CPU and user-defined virtual processors.

Rate this topic


Comment on this topic.
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences