X hits on this document

317 views

0 shares

1 downloads

0 comments

20 / 131

datastore.

Journalize JKM DB2 400 Consistent

Creates the journalizing infrastructure for consistent journalizing on IBM DB2/400 tables using triggers.

Enables consistent Changed Data Capture on IBM DB2/400.

Journalize JKM DB2 400 Simple

Creates the journalizing infrastructure for consistent journalizing on IBM DB2/400 tables using triggers.

Enables consistent Changed Data Capture on IBM DB2/400.

Load

LKM DB2 400 to DB2 400

Loads data from an IBM DB2/400 source database to an IBM DB2/400 staging area database using the native CRTDDMF and CPYF commands.

This LKM uses CRTDDMF to create a DDM file on the target and transfers data from the source staging table to this DDM file using CPYF.

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/400 database and your staging area is on a different DB2/400 database.

Load

LKM SQL to DB2 400 (CPYFRMIMPF)

Loads data from any Generic SQL source database to an IBM DB2/400 staging area using the CPYFRMIMPF command.

This LKM unloads the source data in a temporary file and calls the IBM DB2/400 native loader using the CPYFRMIMPF command to populate the staging table. Because this method uses the native IBM DB2/400 loader, it is often more efficient than the “LKM SQL to SQL” method 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/400 database.

Reverse- Engineer

RKM DB2 400

Retrieves IBM DB2/400 specific metadata. This RKM can be used to extract metadata for physical files, database tables, database views and unique keys. It accesses the underlying DB2/400 catalog tables and can be used to retrieve the physical 10 digits resource names rather than the standard long SQL resource names.

Consider using this RKM if your table names are longer than 10 digits and if you plan to use native commands on your OS/400.

Specific Requirements

Knowledge Modules Reference Guide

20/131

Document info
Document views317
Page views320
Page last viewedSat Dec 03 02:41:53 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments