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. User-defined classes of virtual processorsYou can define special classes of virtual processors to run user-defined routines or to run a DataBlade® module.
  9. Add and drop user-defined virtual processors in online modeYou can add or drop virtual processors in a user-defined class 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.
              • User-defined classes of virtual processorsYou can define special classes of virtual processors to run user-defined routines or to run a DataBlade® module.
                • Determine the number of user-defined virtual processors neededYou can specify as many user-defined virtual processors as your operating system allows.
                • User-defined virtual processorsUser-defined classes of virtual processors protect the database server from ill-behaved user-defined routines.
                • Specify user-defined virtual processorsThe VPCLASS parameter with the vpclass option defines a user-defined VP class. You also can specify a nonyielding user-defined virtual processor.
                • Assign a UDR to a user-defined virtual-processor classThe SQL CREATE FUNCTION statement registers a user-defined routine.
                • Add and drop user-defined virtual processors in online modeYou can add or drop virtual processors in a user-defined class while the database server is online.
              • 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 user-defined virtual processors in online mode

You can add or drop virtual processors in a user-defined class while the database server is online.

For instructions on how to do this, 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