Data Movement Utilities Guide and Reference

Using Import to Move DB2 Data Links Manager Data

Since table data resides in the database, and the files referred to by DATALINK columns reside on Data Links servers, the import utility must move both the database data, and the data files on the corresponding Data Links servers (see Figure 8).

Before running the import utility against the target database:

1. Copy the files that will be referenced to the appropriate Data Links servers. The dlfm_import utility can be used to extract files from an archive that is generated by the dlfm_export utility.
2. Define the prefix name (or names) to the Data Links File Managers on the Data Links servers. (You may want to perform other administrative tasks, such as registering the database.)
3. Update the Data Links server information in the URLs (of the DATALINK columns) from the exported data for the SQL table, if required. (If the Data Links servers of the original configuration are the same as those at the target location, the Data Links server names need not be updated). For DFS, update the cell name information in the URLs (of the DATALINK columns) from the exported data for the SQL table, if required.
4. Define the Data Links servers at the target configuration in the DB2 Data Links Manager configuration file. For DFS, define the cells at the target configuration in the DB2 Data Links Manager configuration file. Register the DB2 Data Links Managers within the target cell using the dlfm server_conf command and the dlfm client_conf command.

When the import utility runs against the target database, files referred to by DATALINK column data are linked on the appropriate Data Links servers.