The options that are described in this section let you enter size information that overrides existing parameters in the onpload database.
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. | 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. |