Modify the size of onpload database parameters

The options that are described in this section let you enter size information that overrides existing parameters in the onpload database.

Read syntax diagramSkip visual syntax diagram
Modifying Parameter Size

|--+--------------------+---------------------------------------|
   +- -A--tapehead------+   
   +- -B--blocksize-----+   
   +- -G--swapbytes-----+   
   +- -I--commit_int----+   
   +- -a--iobufsize-----+   
   +- -b -bufsize-------+   
   +- -e--maxerrors-----+   
   +- -i--prog_interval-+   
   +- -n--numrecs-------+   
   +- -s--startrec------+   
   '- -t--numtapes------'   

Element Purpose Key considerations
-A tapehead Tells onpload to skip the specified number of bytes on the tape before it starts reading data records. This option is available only from the command line.

For specific details on this option, see The session table in the onpload database.

-B blocksize Sets the tape I/O block size (bytes). If the data source is a device array, this setting is ignored. To use ipload, see Figure 2.
-G swapbytes Sets the number of bytes in a swap group. This option is available only from the command line.

This option globally reverses the byte order in the input data stream. Each group of bytes is swapped with the group of bytes that follows it.

-I commit_int Sets the number of records to process before doing a commit. This option applies only to deluxe mode.

To use ipload, see Figure 1.

-a iobufsize Sets the size (kilobytes) of the asynchronous I/O buffers, the memory buffers used to transfer data to and from tapes and files. This option is available only from the command line

This value overrides the value (AIOBUFSIZE) set in the HPL configuration file (plconfig).

For specific details on this option, see The AIOBUFSIZE configuration parameter.

-b bufsize Sets the size (kilobytes) of the server stream buffer, the memory buffer used to write records to the database. This option is available only from the command line.

Larger buffers result in more efficient data exchange with the database. This value overrides the value (STRMBUFFSIZE) set in the HPL configuration file (plconfig).

For specific details on this option, see The STRMBUFFSIZE configuration parameter.

-e maxerrors Sets the error threshold that causes the load or unload session to shut down. If no number is specified, the default is to process all records. To use ipload, see Figure 1.
-i prog_interval Sets the number of records to process before making an entry in the log file specified by the -l option. This option is available only from the command line.

If no log file is specified, progress messages are sent to stdout. If the -i option is omitted, the default number is 1000. To set, see The onpload -i option.

-n numrecs Sets the number of records to load. If no number is specified, all records are processed. The -n option does not affect unload operations because pload cannot maintain row ordering. To use ipload, see Figure 1.
-s startrec Sets the starting record to load. This option is used to skip records. For example, setting -s to 10 starts the loading at the 10th record, so that if the file contains 20 records, 11 records are loaded. Setting -s to 0 or 1 the load starts with the first record. If you do not set this option, the load starts with the first record.

The -s option does not affect unload operations because pload cannot maintain row ordering. To use ipload, see Figure 1.

-t numtapes Specifies the number of tapes to load. If you do not set this option, the default value is 1. To use ipload, see Figure 1.

Copyright© 2018 HCL Technologies Limited