PowerCenter All Products
IBM DB2 external loader operation mode. Select one of the following operation modes:
External Loader Executable
Name of the IBM DB2 EE external loader executable file. Enter one of the following file names depending on the IBM DB2 client version installed on the machine where the Integration Service process runs:
DB2 Server Location
Location of the IBM DB2 database server relative to the Integration Service. Select Local if the database server resides on the machine hosting the Integration Service. Select Remote if the database server resides on another machine.
Method of loading data. Select Is Staged to load data to a flat file staging area before loading to the database. By default, the data is loaded to the database using a named pipe.
Sets tablespaces in backup pending state if forward recovery is enabled. If you disable forward recovery, the IBM DB2 tablespace will not set to backup pending state. If the IBM DB2 tablespace is in backup pending state, you must fully back up the database before you perform any other operation on the tablespace.