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.
Manage the High-Performance Loader
HPL performanceYou can improve the HPL performance by preparing an environment that is optimized for the particular load or unload job that you are performing.
HPL usage tasks
Assess information for loading or unloading external dataWhen you load or unload data from an external source, you must assess the type of data and the amount of conversion that is required so that you can choose appropriate configuration parameters.

Assess information for loading or unloading external data

When you load or unload data from an external source, you must assess the type of data and the amount of conversion that is required so that you can choose appropriate configuration parameters.

The following sections show possible configuration parameters for two different types of load jobs. Suppose your hardware has the following configuration:

Eight CPU symmetric multiprocessors, each about 40 MIPS
Several (say 16) 300-MB disks (for the database)
Four 1.2-MB tape devices (to load to and unload from)
512-MB memory

You also have this information about your system:

The database server is running with seven CPU virtual processors.
The data that you want to load has a row of about 150 bytes with a mix of INT, DATE, DECIMAL, CHAR, and VARCHAR data types. (This is similar to the LINEITEM table in the TPC-D database).

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.