While the database server is in online mode, you can start additional virtual processors for the following classes: CPU, AIO, PIO, LIO, SHM, STR, TLI, SOC, JVP, and user-defined. The database server automatically starts one virtual processor each in the LIO and PIO classes unless mirroring is used, in which case it starts two.
You can start these additional virtual processors with one of the following methods:
You can also start additional virtual processors for user-defined classes to run user-defined routines. For more information about user-defined virtual processors, refer to Assigning a UDR to a User-Defined Virtual-Processor Class.
Use the -p option of the onmode command to add virtual processors while the database server is in online mode. Specify the number of virtual processors that you want to add with a positive number. As an option, you can precede the number of virtual processors with a plus sign (+). Following the number, specify the virtual processor class in lowercase letters. For example, either of the following commands starts four additional virtual processors in the AIO class:
onmode -p 4 aio onmode -p +4 aio
The onmode utility starts the additional virtual processors immediately.
You can add virtual processors to only one class at a time. To add virtual processors for another class, you must run onmode again.
To use ON–Monitor to add virtual processors while the database server is online, select the Modes > Add-Proc option. You can add virtual processors in the following classes: CPU, AIO, LIO, PIO, and NET.
To specify network virtual processors, first enter the number of virtual processors and then enter one of the following interface/protocol combinations: ipcshm, ipcstr, tlitcp, tlispx, or soctcp.
You cannot use ON–Monitor to start additional virtual processors for a user-defined class. For more information, refer to Adding Virtual Processors in Online Mode with onmode.
When you add network virtual processors, you are adding poll threads, each of which requires its own virtual processor to run. If you attempt to add poll threads for a protocol while the database server is in online mode, and you have specified in the NETTYPE parameter that the poll threads run in the CPU class, the database server does not start the new poll threads if no CPU virtual processors are available to run them.
In the following example, the poll threads handle a total of 240 connections:
NETTYPE ipcshm,4,60,CPU # Configure poll thread(s) for nettype
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]