Data Movement Utilities Guide and Reference

Using Load

Before Using Load

Before invoking the load utility, you must be connected to (or be able to implicitly connect to) the database into which the data will be loaded. Since the utility will issue a COMMIT statement, you should complete all transactions and release all locks by performing either a COMMIT or a ROLLBACK before invoking load.

Since data is loaded in the sequence that appears in the input file, if a particular sequence is desired, the data should be sorted before a load operation is attempted.

If clustering is required, the data should be sorted on the clustering index prior to loading.

Invoking Load

The load utility can be invoked through:

• The command line processor (CLP).

  Following is an example of the LOAD command issued through the CLP:

     db2 load from stafftab.ixf of ixf messages staff.msgs
        insert into userid.staff copy yes use tsm data buffer 4000
  

  In this example:

  • Any warning or error messages are placed in the staff.msgs file.
  • A copy of the changes made is stored in Tivoli Storage Manager (TSM, formerly ADSM). For more information about TSM, see the "Tivoli Storage Manager" section of the database recovery chapter in the Administration Guide.
  • Four thousand pages of buffer space are to be used during the load operation.

  Following is another example of the LOAD command issued through the CLP:

     db2 load from stafftab.ixf of ixf messages staff.msgs
        tempfiles path /u/myuser replace into staff
  

  In this example:

  • The table data is being replaced.
  • The TEMPFILES PATH parameter is used to specify /u/myuser as the server path into which temporary files will be written.

  Note:

  These examples use relative path names for the load input file. Relative path names are only allowed on calls from a client on the same node as the database. The use of fully qualified path names is recommended.

• The Load notebook in the Control Center. To open the Load notebook:
  1. From the Control Center, expand the object tree until you find the Tables folder.
  2. Click on the Tables folder. Any existing tables are displayed in the pane on the right side of the window (the contents pane).
  3. Click the right mouse button on the table you want in the contents pane, and select Load from the pop-up menu. The Load notebook opens.

  For general information about the Control Center, see the Administration Guide. Detailed information is provided through the online help facility within the Control Center.

• An application programming interface (API), sqluload. For information about this API, see Load API. For general information about creating applications containing DB2 administrative APIs, see the Application Building Guide.