DB2 Help

This box lists the path names to the data files that contain the large object (LOB) data to be loaded. Use the Add push button to add a path name to this box. You can also select a path name to be changed, removed, or rearranged.

The names of the LOB data files are stored in the data file column that will be loaded into the table's LOB column.

This box is available only when the Retrieve large objects (LOBs) from the specified paths (LOBSINFILE) check box is selected.

Add

Click on this push button to open the Add window so you can add the name of a LOB path to the LOB paths box.

The new entry is added to the list following the entry that is currently selected. If no entry is selected, the new entry is appended to the list.

Change

Click on this push button to open the Change window so you can change the name of the selected LOB path in the LOB paths box.

This push button is available only when a name is selected in the LOB paths box.

Remove

Click on this push button to remove the selected LOB path names from the LOB paths box. (The actual LOB files are not removed from the system.)

This push button is available only when one or more names are selected in the LOB paths box.

Click on this push button to move up one position the name of the selected LOB path in the LOB paths box.

This push button is available only when a name is selected in the LOB paths box.

Down

Click on this push button to move down one position the name of the selected LOB path in the LOB paths box.

This push button is available only when a name is selected in the LOB paths box.

Ignore code page mismatches and suppress translation (FORCEIN)

Select this check box to specify that code page values in the input file not be compared with the application and the database. If you select this check box, the load utility will accept data regardless of code page mismatches and will suppress translation between code pages.

Suppress warnings about rejected rows (NOROWWARNINGS)

Select this check box to stop DB2 from issuing warnings when rows are rejected during the load process.

Load each row without checking target length (NOCHECKLENGTHS)

Select this check box to specify that no checking be done when loading data into fixed length fields. The default is to check the target fields to verify that they are large enough for the data. If you select this check box, then no checking is done and an attempt is made to load each row.

Use default values on defaultable columns when missing input data (USEDEFAULTS)

Select this check box to specify that if an input value is missing for a particular table column and that table column has a default defined on it, the default value will be inserted in place of the missing value.

Percentage of free space in each data page (PAGEFREESPACE)

This field contains the percentage of each data space that is to be left as free space. To change this percentage, use one of these methods:

Select the up or down arrows to spin through the available choices.
Type in a value.

For example, if you specify 50, then 50% of each data page is left as free space. The default value of 0 specifies that no space in each data page will be specifically left as free space.

If you specify an invalid value because of the minimum row size (for example, a row that is at least 3000 bytes long and a page free space of 50), the row will be placed on a new page. If you specify 100, each row will reside on a new page.

Percentage of total free space reserved in the table (TOTALFREESPACE)

This field contains the percentage of the total pages in the table that is to be appended to the end of the table as free space. To change this percentage, use one of these methods:

Select the up or down arrows to spin through the available choices.
Type in a value.

For example, if you select 20 and the table has 50 pages, then 10 additional empty pages will be appended. The total number of data pages for the table will be 60.

The default of 0 specifies that free space will not be appended to the end of the table.