Loading data into a table

Use the Load notebook to specify details about how to load data into the table you selected.

Authorities and privileges

To load data into a table:

1. Open the load notebook:
   • Open the Load notebook.
   • Open the Load Table Partition notebook.
2. Specify the location of and type of data to be loaded.

   Note:

   Data must be properly split into separate files before it can be loaded into a table partition that resides in a multipartition nodegroup.

3. Specify how to load the data into the table columns for the data type you selected in step 2:
   • ASC data
   • DEL data
   • IXF data
4. Specify conditions for loading the data file rows into the table (for example, whether you want to replace any data that already exists in the table).
5. Optional: Specify whether and how statistics will be collected during the load process.
6. Optional: Specify whether and how a copy of the changes made to the table will be saved.
7. Optional: Specify a message file, remote file, and other parameters for the load process.
8. Click on OK to begin the load process.

Page controls

• File
• Columns
• Counts
• Statistics
• Copy Options
• Others

Fields and controls

• OK
• Cancel
• Show Command

Related information

• Restarting an interrupted load
• Terminating an interrupted load
• Loading data information -- See the Data Movement Utilities Guide and Reference
• Splitting Data with db2split -- See the Data Movement Utilities Guide and Reference
• Load command -- See the Command Reference
• Showing Commands or SQL