Multiple Coservers on Each Node of a Multiple-Node Platform

A configuration of multiple coservers on each node is best suited to parallel-processing platforms composed of nodes that:

• each have over 8 CPUs or an amount of physical memory that is at least double the size of the address space of a single process.
• cannot be partitioned to form separate nodes.
• each have enough local disk space to support an equal portion of the data that is required for the intended application, plus a suitable amount of space for temporary tables and sort files.

The use of multiple coservers on each node can help to balance the processing load across the available memory and CPU resources. Each coserver requires a coserver section in the ONCONFIG file. Each node requires an entry in the sqlhosts connectivity file and an entry in the operating system hosts network file. For more information, refer to Network-Configuration Files.

Parallel processing can occur both within coservers and between coservers. To calculate the number of CPUs available to the database server, you can multiply NUMCPUVPS by the number of COSERVER parameters listed in the ONCONFIG file.