The onpload -i option
You can specify the number of records to process before onpload reports the progress in an entry in the log file with the -i option.
The onpload utility calculates the progress message count in the pload log file as equal to the number of rows processed, but rounded down to the nearest multiple of the value of progress_interval. For example, if the number of rows processed is 910 and the value of progress_interval is 100, then the progress message count is 900.
The onpload utility updates the row count
only once for each stream buffer of data that it processes. Thus,
reducing the row count on the -i option does
not necessarily increase the number of progress messages in the log
file. For example, if the stream buffer holds 910 rows of data, setting row_count to 10
, 100
, and 900
has
the same effect: onpload writes one progress
message.