Running the Load Job

If you click Run in the Load Job window, the Active Job window appears, as Figure 23 shows. The Active Job window displays the progress of your job and indicates when the job completes. When the Active Job window indicates that the load job is complete, click OK to return to the Load Job Select window.

Before you run a load job, you might want to view the data-file records according to a specified format to check your definitions. For more information, see Previewing Data-File Records.

After you run an express-mode load, you must make a level-0 backup before you can access the table that you loaded.

Making 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 IBM Informix: Dynamic Server Administrator's Guide. For information about making backups, see either the IBM Informix: Archive and Backup Guide for IBM Informix Dynamic Server or the IBM Informix: Backup and Restore Guide, depending on the system you use.

Problems During a Load Job

If you encounter any problems during the load, examine the various files that onpload creates. For information on how to review these files, see Browsing.

Because of operating-system limitations, the onpload utility cannot load successfully from a file (on disk) that is larger than 2 gigabytes on a platform that is less than a 64-bit platform. If you try to read a file that is larger than 2 gigabytes, onpload HPL fails only after it processes the first 2 gigabytes of data. The HPL log file reports the following error: