DB Alias Tab - iSeries, Load Request Editor

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.