PowerCenter
- PowerCenter 10.5.6
- All Products
Attribute
| Default Value
| Description
|
---|---|---|
Opmode | Insert | IBM DB2 external loader operation mode. Select one of the following operation modes:
|
External Loader Executable | db2atld | Name of the IBM DB2 EEE external loader executable file. |
Split File Location | n/a | Location of the split files. The external loader creates split files if you configure SPLIT_ONLY loading mode. |
Output Nodes | n/a | Database partitions on which the load operation is to be performed. |
Split Nodes | n/a | Database partitions that determine how to split the data. If you do not specify this attribute, the external loader determines an optimal splitting method. |
Mode | Split and load | Loading mode the external loader uses to load the data. Select one of the following loading modes:
|
Max Num Splitters | 25 | Maximum number of splitter processes. |
Force | No | Forces the external loader operation to continue even if it determines at startup time that some target partitions or tablespaces are offline. |
Status Interval | 100 | Number of megabytes of data the external loader loads before writing a progress message to the external loader log. Specify a value between 1 and 4,000 MB. |
Ports | 6000-6063 | Range of TCP ports the external loader uses to create sockets for internal communications with the IBM DB2 server. |
Check Level | Nocheck | Checks for record truncation during input or output. |
Map File Input | n/a | Name of the file that specifies the partitioning map. To use a customized partitioning map, specify this attribute. Generate a customized partitioning map when you run the external loader in Analyze loading mode. |
Map File Output | n/a | Name of the partitioning map when you run the external loader in Analyze loading mode. You must specify this attribute if you want to run the external loader in Analyze loading mode. |
Trace | 0 | Number of rows the external loader traces when you need to review a dump of the data conversion process and output of hashing values. |
Is Staged | Disabled | Method of loading data. Select Is Staged to load data to a flat file staging area before loading to the database. Otherwise, the data is loaded to the database using a named pipe. |
Date Format | mm/dd/yyyy | Date format. Must match the date format you define in the target definition. IBM DB2 supports the following date formats:
|