HPL usage tasks

Three tasks that you might need to perform for the High-Performance Loader (HPL) are:

Reorganize computer configuration
If you are not changing the table schema, use a No-Conversion Job to unload and load when you need to reorganize the configuration of your computer or change to a different computer. The no-conversion mode is the fastest means of performing an unload job or a load job, because rows are unloaded in HCL Informix® internal format with no conversion and reloaded in the same fashion.
Alter the schema of a table
When you need to alter a table (add, drop, or change the data type of columns), use the Fixed Internal format. In Fixed Internal format, rows are unloaded in HCL Informix internal format on a column-by-column basis. Thus you can drop, add, or modify columns and still minimize conversion overhead.
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.

Parent topic: HPL performance

Related concepts: