X hits on this document

364 views

0 shares

1 downloads

0 comments

17 / 131

Load

LKM DB2 UDB to DB2 UDB (EXPORT_IMPORT)

Loads data from an IBM DB2 UDB source database to an IBM DB2 UDB staging area database using the native EXPORT / IMPORT commands.

This module uses the EXPORT CLP command to extract data in a temporary file. Data is then loaded in the target staging DB2 UDB table using the IMPORT CLP command. This method if often more efficient than the standard “LKM SQL to SQL” when dealing with large volumes of data.

Consider using this LKM if your source tables are located on a DB2 UDB database and your staging area is on a different DB2 UDB database.

Load

LKM File to DB2 UDB (LOAD)

Loads data from a File to a DB2 UDB staging area database using the native CLP LOAD Command.

Depending on the file type (Fixed or Delimited) this LKM will generate the appropriate LOAD script in a temporary directory. This script is then executed by the CLP LOAD command and automatically deleted at the end of the execution. Because this method uses the native IBM DB2 loaders, it is more efficient than the standard “LKM File to SQL” when dealing with large volumes of data.

Consider using this LKM if your source is a large flat file and your staging area is an IBM DB2 UDB database.

Load

LKM SQL to DB2 UDB

Loads data from any Generic SQL source database to an IBM DB2 UDB staging area. This LKM is similar to the standard “LKM SQL to SQL” described in section “Generic SQL” except that you can specify some additional specific IBM DB2 UDB parameters.

Load

LKM SQL to DB2 UDB (LOAD)

Loads data from any Generic SQL source database to an IBM DB2 UDB staging area using the CLP LOAD command.

This LKM unloads the source data in a temporary file and calls the IBM DB2 native loader using the CLP LOAD command to populate the staging table. Because this method uses the native IBM DB2 loader, it is often more efficient than the “LKM SQL to SQL” or “LKM SQL to DB2 UDB” methods when dealing with large volumes of data.

Consider using this LKM if your source data located on a generic database is large, and when your staging area is an IBM DB2 UDB database.

Web service

SKM IBM UDB

Generates data access Web services for IBM DB2 UDB databases. Refer to “SKM SQL” in section “Generic SQL” for more details.

This SKM is optimized for the IBM DB2 UDB database.

Specific Requirements

Knowledge Modules Reference Guide

17/131

Document info
Document views364
Page views367
Page last viewedTue Dec 06 08:27:57 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments