Home | Previous Page | Next Page   The onpload Utility >

Modifying Parameter Size

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 diagramModifying 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. Restrictions: This option is available only from the command line.

References: For specific details on this option, see Session Table.

-B blocksize Sets the tape I/O block size (bytes). Additional Information: If the data source is a device array, this setting is ignored. To use ipload, see Figure 51.
-G swapbytes Sets the number of bytes in a swap group.

Restrictions: This option is available only from the command line.

Additional Information: 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.

Restrictions: This option applies only to deluxe mode.

Additional Information: To use ipload, see Figure 111.

-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.

Restrictions: This option is available only from the command line.

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

References: For specific details on this option, see AIOBUFSIZE.

-b bufsize Sets the size (kilobytes) of the server stream buffer, the memory buffer used to write records to the database.

Restrictions: This option is available only from the command line.

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

References: For specific details on this option, see STRMBUFSIZE.

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

Restrictions: This option is available only from the command line.

Additional Information: 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 Using the -i Option.

-n numrecs Sets the number of records to load. Additional Information: 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 111.
-s startrec Sets the starting record to load.

Additional Information: This option is used to skip records. For example, setting -s to 10 starts the loading at the tenth 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 111.

-t numtapes Specifies the number of tapes to load. Additional Information: If you do not set this option, the default value is 1. To use ipload, see Figure 111.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]