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.
High-Performance Loader overview
Environment variables needed for the HPLThe is part of the database server, so you must start the database server before you use the HPL. Before you start the database server and use HPL, you must set environment variables.
Preparing multiple onpload databasesEach database server can have only one active onpload database. In most cases, you can use the default onpload database, which is named onpload. If you choose to prepare multiple databases to hold different types of control information, you must set the DBONPLOAD environment variable before you can run a load or unload.

Preparing multiple onpload databases

Each database server can have only one active onpload database. In most cases, you can use the default onpload database, which is named onpload. If you choose to prepare multiple databases to hold different types of control information, you must set the DBONPLOAD environment variable before you can run a load or unload.

Procedure

To prepare multiple onpload databases with ipload:

Set the DBONPLOAD environment variable to the name of the alternative onpload database.
Restart ipload.
Use ipload to prepare the alternative database.

Results

During load and unload jobs, the ipload, onpload, and onpladm utilities use the value of the DBONPLOAD environment variable that is set in the client environment, regardless of whether the DBONPLOAD environment variable is set on the server. The ipload, onpload, and onpladm utilities use the value of the DBONPLOAD environment variable that is set on the server only if the DBONPLOAD environment variable is not set in the client environment.

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.