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.
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.
Effect of configuration on CPU utilizationThe combination of operating-system and HCL OneDB™ configuration parameters can affect CPU utilization. You can change the settings of the HCL OneDB™ configuration parameters that directly affect CPU utilization, and you can adjust the settings for different types of workloads.
Configuration parameters and environment variables that affect CPU utilizationSome configuration parameters and environment variables affect CPU utilization. You might need to adjust the settings of these parameters and variables when you consider methods of improving performance.
Configuring poll threadsThe NETTYPE configuration parameter configures poll threads for each connection type that your instance of the database server supports. If your database server instance supports connections over more than one interface or protocol, you must specify a separate NETTYPE configuration parameter for each connection type.
Specifying the connection protocolThe first NETTYPE entry, which specifies the protocol for a given connection type, applies to all dbservernames associated with that type. Subsequent NETTYPE entries for that connection type are ignored.

Specifying the connection protocol

The first NETTYPE entry, which specifies the protocol for a given connection type, applies to all dbservernames associated with that type. Subsequent NETTYPE entries for that connection type are ignored.

NETTYPE entries are required for connection types that are used for outgoing communication only even if those connection types are not listed in the sqlhosts information.

UNIX™ Only

The following protocols apply to UNIX platforms:

IPCSHM
TLITCP
IPCSTR
SOCTCP
TLIIMC
SOCIMC
SQLMUX
SOCSSL

Windows™ Only

The following protocols apply to Windows platforms:

SOCTCP
IPCNMP
SQLMUX
SOCSSL