Optim™ supports loading
data into an iSeries® DBMS,
using the DB2® CLIENT IMPORT
command. Use the DB Alias tab to define the
parameters needed. A DB2 LUW
DB Alias must exist before you create the Load Request.
The DB Alias tab of the Load Request Editor has the options
described below when loading to an iSeries DBMS.
Mode
- Insert
- Inserts rows from the Source File into empty destination
tables. If destination tables contain data, the loader returns an
error. This error occurs only if a primary key column is defined and
this process attempts to insert the same value into a table row.
- Replace
- Clears and replaces all of the existing rows in
the destination tables with the rows from the Source File.
Options
- Perform Load
- Select this check box to run the DB2 CLIENT IMPORT command automatically after
file conversion processing is complete. If you clear this check box,
the Load Process prepares the data in the appropriate format and creates
the BAT file, but does not initiate the command. To run the command,
edit the BAT file to include the proper password information and then
run the BAT file.
- Delete files if Successful
- Select this check box to delete the data files after
the DB2 CLIENT IMPORT command
completes successfully. If you select this check box, Fast Load Confirmation
is unavailable.
Note: Fast Load Confirmation reduces processing time
when you run a Load Request that has run before. See
Process a Load Request for
detailed information.
- Delete files if Failure
- Select this check box to delete the data files if
the process does not complete successfully. If you select this check
box, Fast Load Confirmation is unavailable.
- Load When Source Is Empty
- Select this check box to perform the load if a table to be loaded
contains no rows. If you do not select this check box, any tables
in the Archive File containing no rows will be skipped in the load
phase. Using load with an empty source table deletes rows from the
target table, resulting in a clean test environment.
File Type
- ASCII
- For DB2 Linux, UNIX or Windows, use to import data into
other DBRM instances or EEE sites.
- ASCII Delimited
- For DB2 Linux, UNIX or Windows, use to import data into
other DBRM instances or EEE sites. If you select this file type, select
a valid delimiter.
- iSeries IXF
- For iSeries, use to
import data into an iSeries instance.
- IXF
- For DB2 Linux, UNIX or Windows, use as the preferred
import file type for expedient processing.
- Teradata ASCII
- For a Teradata loader, use to import data into a Teradata instance.
This file type is valid for Teradata Fast Load and Multi Load.
- Teradata Delimited
- For a Teradata loader, use to import data into a Teradata instance.
If you select this file type, select a valid delimiter. This file
type is valid for Teradata Fast Load and Multi Load.
- Delimiter
- To avoid error, the delimiter selected must not appear within
the data.
Work path for interim files
Specify
a default directory path for storing the temporary loader files.