The onpload utility

The onpload utility has the following features:
  • Converts, filters, and moves data between a database and a storage device
  • Uses information from the onpload database to run the load and unload jobs and to convert the data
  • Records information during a load about data records that do not meet the load criteria

The onpload utility can load or unload data from files that are larger than 2 GB and can generate .log, .rej and .flt files that are larger than 2 GB.

The onpload database must be accessible from the machine on which the onpload utility is run. It does not need to be on the same machine.

The database that the onpload loads or unloads must be in a database server instance on the machine that is running the onpload (or ipload or onpladm) utility.

You can start onpload by using ipload or from the command line.

When you start onpload from ipload, the onpload and ipload utilities communicate by using a socket connection. The onpload utility runs independently from ipload (see the information to the right of the vertical line in Figure 1).

Copyright© 2018 HCL Technologies Limited