Loading data into a table using the Load wizard - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Load wizard to load data into a selected table. The Load wizard guides you through load configuration and the selection of options. The Load wizard also lets you copy an existing load task and use the setting values of the existing load task for your new load task.

Before you begin

To load data into a table, you must have one of the following authorities:

DATAACCESS authority
LOAD or DBADM authority on the database and:
- INSERT privilege on the table if you load data in INSERT mode, TERMINATE mode (to terminate a previous load operation), or RESTART mode (to restart a previous load insert operation)
- INSERT and DELETE privilege on the table if you load data in REPLACE mode, TERMINATE mode (to terminate a previous load replace operation), or RESTART mode (to restart a previous load replace operation)
- INSERT privilege on the exception table, if one is used during the load operation
  Note: Because all load processes (and all DB2® server processes in general) are owned by the instance owner, and all these processes use the identification of the instance owner to access the required files, the instance owner must have read access to input data files. The input data files must be readable by the instance owner, regardless of who performs the load operation.

About this task

If you want to use exception tables with the load, you must create the exception tables before running the load task.

Note: If the table you are working with is a replication source, the changes made will not be captured in replication.

Procedure

Open the Load wizard:
1. From the Control Center, expand the object tree until you find the Tables folder.
2. Click the Tables folder. Any existing tables are displayed in the pane on the right side of the window (the contents pane).
3. Right-click the table you want in the contents pane and select Load from the pop-up menu. The Load wizard opens.
Complete each of the applicable wizard pages. Click the wizard overview link on the first page for more information. The Finish push button is enabled when you specify enough information for the wizard to create the load task.