Data Movement Utilities Guide and Reference
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.)
- Ensure that DB2 Data Links Manager is installed on the Data Links servers
that will be referred to by the DATALINK column values. For DFS, ensure
that the DB2 Data Links Managers within the target cell are
registered.
- Ensure that the database is registered with the DB2 Data Links
Manager.
- Copy to the appropriate Data Links servers all files that will be inserted
as DATALINK values.
- Define the prefix name (or names) to the DB2 Data Links Managers on the
Data Links servers.
- Register the Data Links servers referred to by DATALINK data (to be
loaded) in the DB2 Data Links Manager configuration file. For DFS,
register the cells at the target configuration 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:
- Start the Data Links server and the DB2 Data Links Manager.
- 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.
Following are load utility features that are not supported when loading
tables with DATALINK columns:
- CPU_PARALLELISM (the value is forced to 1)
- LOAD REPLACE
- LOAD TERMINATE
- LOAD COPY
[ Top of Page | Previous Page | Next Page ]