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 Informix® database servers.
High-Performance Loader User's GuideThe describes how to use the HCL Informix® to load and unload large quantities of data efficiently to or from Informix® databases.
AppendixesThis section contains additional reference information.
High-Performance Loader configuration fileThe default $INFORMIXDIR/etc/plconfig.std file on UNIX™ or %\INFORMIXDIR%\etc\plconfig.std on Windows™ is the high-performance loader configuration file.
The CONVERTVPS configuration parameterThe CONVERTVPS parameter limits the maximum number of VPs used for convert threads. This parameter limits the number of VPs that the onpload client uses so that onpload does not monopolize system resources.

The CONVERTVPS configuration parameter

The CONVERTVPS parameter limits the maximum number of VPs used for convert threads. This parameter limits the number of VPs that the onpload client uses so that onpload does not monopolize system resources.

Setting CONVERTVPS too large can cause performance degradation. Do not set more converter VPs than there are physical CPUs. If the number of CONVERTVPS exceeds the number of physical CPUs, system resources are consumed with no performance benefit.

On single-CPU computers, increasing this parameter has a negative effect on performance.

Default value: Single-processor computer: 1
Multiprocessor computer: 50 percent of physical CPUs
Range of values: From 1 to the number of physical CPUs
See: Assess information for loading or unloading external data

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.