Online Documentation for SQL Manager for DB2

Specifying load parameters

This step allows you to specify a number of parameters for the load operation.

Use the spinner controls to define the corresponding parameter values.

The number of physical records to be loaded

Stands for the ROWCOUNT parameter.

This parameter allows you to restrict the number of rows to be loaded into the table.

The number of records to load before establishing a consistency point

Stands for the SAVECOUNT parameter.

This value is converted to a page count, and rounded up to intervals of the extent size.

The number of 4KB pages (regardless of the degree of parallelism) to use as buffered space for transferring data within the utility

Stands for the DATA BUFFER parameter.

If the value specified is less than the algorithmic minimum, the minimum required resource is used, and no warning is returned

Specify a value that overrides the SORTHEAP database configuration parameter during a load operation

Stands for the SORT BUFFER parameter.

This parameter is useful for throttling the sort memory used by LOAD without changing the value of SORTHEAP, which would also affect general query processing.

Stop the load operation after selected number of warnings

Stands for the WARNINGCOUNT parameter.

This parameter should be defined if no warnings are expected, but verification that the correct file and table are being used is desired.

Click the Next button to proceed to the Specifying fields to load step of the wizard.