Use the Others page of the Load notebook to specify various options for the
load process.
Fields and controls
To specify the various options for the load process:
- Open the Others page of the Load notebook.
- Optional: Specify locations where temporary files used during index
creation will be written by clicking on Add. The Add window
opens so you can add directories to the Temporary directories used during
index creation list 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.
- Optional: Modify the list of temporary directories in the
Temporary directories used during index creation list box.
You can change or rearrange their order by selecting a name and using the
Change, Up, and Down push buttons. You
can remove directory names from the list by selecting the names and using the
Remove push button.
- Optional: Select other options by selecting the appropriate check
boxes on this notebook page.
- Optional: Specify degrees of CPU parallelism and disk parallelism by
using the appropriate spin buttons on this notebook page.
- Optional: Select a value in the Percentage of
free space to be left on index pages field to specify what
percentage of each index page to leave as free space when building an
index. Select the check box to activate the percentage spin
button.
- Optional: Specify the file where messages can be written during the
load process in the Message file
field.
- Optional: Specify a base name to be used when temporary files are
created during the load process in the Remote
file field.
- Optional: Use the Exception table
schema and Name boxes to specify a
table in which rows that violate constraints will be written.
- If you have specified all required information for the load process, you
can start the load process now by clicking on OK. Otherwise,
to specify required or optional information, or to change default values, go
to one of the other notebook pages.
Related information