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.
Load data to a database tableThis section describes the load process.
The Load Job windowsYou can create, save, and run a load job from the Load Job Select window and the Load Job window. The Load Job window visually represents the various components of a load. After you select the components, you can save the load job for future use or run it immediately.
Run the load job
Make a level-0 backupExpress-mode loads do not log loaded data. After an express-mode load, onpload sets the table to read-only as a protective measure. To make the table available for write access, you must do a level-0 backup for all the dbspaces that the fragments of the loaded table occupy. The level-0 backup allows data recovery for the table in case of future database corruption.

Make a level-0 backup

Express-mode loads do not log loaded data. After an express-mode load, onpload sets the table to read-only as a protective measure. To make the table available for write access, you must do a level-0 backup for all the dbspaces that the fragments of the loaded table occupy. The level-0 backup allows data recovery for the table in case of future database corruption.

If you do not need to provide for data recovery, you can use /dev/null as the backup device for the level-0 backup. This strategy makes the table available for write access without actually backing up the data. If a user attempts to write into the table before you make a level-0 backup, the database server issues an error message.

If you run several express-load jobs on different tables in a database, you can complete all of the loads before you perform the level-0 backup. However, if you try to do a second load on the same table without making a level-0 backup, the database server issues an error message.

For discussions of table fragments and dbspaces, see the Informix® Administrator's Guide. For information about making backups, see the Informix Backup and Restore Guide.

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.