Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Configuring IBM DB2 EE External Loader Attributes

Configuring IBM DB2 EE External Loader Attributes

The IBM DB2 EE external loader creates a single log or multiple logs depending on the following databases that you are loading to:
  • IBM DB2 EE version 8.x or non-partitioned IBM DB2 version 9.x.
    The external loader creates a single external loader log with the extension .ldrlog in the same directory as the target flat files.
  • IBM DB2 EEE version 8.x or partitioned IBM DB2 version 9.x.
    The external loader creates multiple external loader logs in the same directory as the target flat files. The loader logs have the following extensions:
    • ldrlog.load.
      number
      . Created by the Load Agent external loader process. The Load Agent creates two log files.
    • ldrlog.part.
      partition_number
      . Created by the Partitioning Agent external loader process. The Partitioning Agent can create multiple log files depending on the number of partitions in the target table.
    • ldrlog.prep.
      partition_number
      . Created by the Pre-partitioning Agent external loader process. The Pre-partitioning Agent can create multiple log files depending on the number of partitions in the target table.
    • ldrlog. Created by the IBM DB2 EE external loader.
The following table describes attributes for IBM DB2 EE external loader connections:
Attributes
Default Value
Description
Opmode
Insert
IBM DB2 external loader operation mode. Select one of the following operation modes:
  • Insert
  • Replace
  • Restart
  • Terminate
External Loader Executable
db2load
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:
  • db2load. Use for the IBM DB2 client earlier than version 9.5.
  • db2load95. Use for the IBM DB2 client version 9.5 and later.
DB2 Server Location
Remote
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.
Is Staged
Disabled
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.
Recoverable
Enabled
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.


Updated June 25, 2020