Data Movement Utilities Guide and Reference

Using Load to Move DB2 Data Links Manager Data

If you are loading data into a table with a DATALINK column that is defined with FILE LINK CONTROL, perform the following steps before invoking the load utility. (If all the DATALINK columns are defined with NO LINK CONTROL, these steps are not necessary.)

1. Ensure that DB2 Data Links Manager is installed on the Data Links servers that will be referred to by the DATALINK column values.

2. Ensure that the database is registered with the DB2 Data Links Manager.

3. Copy to the appropriate Data Links servers all files that will be inserted as DATALINK values.

4. Define the prefix name (or names) to the DB2 Data Links Managers on the Data Links servers.

5. Register the Data Links servers referred to by DATALINK data (to be loaded) in the DB2 Data Links Manager configuration file.

The connection between DB2 and the Data Links server may fail while running the load utility, causing the load operation to fail. If this occurs:

1. Start the Data Links server and DB2 Data Links Manager.

2. Issue the LOAD RESTART command (see LOAD Command).

Links that fail during the load operation are considered to be data integrity violations, and are handled in much the same way as unique index violations. Consequently, a special exception has been defined for loading tables that have one or more DATALINK columns. For additional information, refer to the description of exceptions in the SQL Reference.

[ DB2 List of Books | Search the DB2 Books ]