Load Process

Those sites using LOADPLUS can display a set of panels specific to LOADPLUS. (See LOADPLUS Utility Parameters for more information.)

The Load utility can be used in place of the Move Insert Process. This may be desirable when:

• The number of rows to be inserted is so large that the speed of the Load utility offsets the advantages of the Insert Process.
• The data contains Referential Integrity (RI) cycles that make it impossible for the Insert Process to successfully insert all data.
• The site-defined Maximum Insert Rows limit is less than the number of rows in the Extract File.
• You want to insert data without logging. The Load Process prompts you to specify whether the logging is performed.

A database Load utility and the LOAD phase of LOADPLUS require exclusive control of the database. When using the Move Insert Process, the database is available to all users.

Sorting

Generally, the rows in the Extract File are loaded in the order in which they are processed. However, if a cluster index has been defined for a table, you can sort the rows according to that index before loading them.

LOAD Menu

The following panel is displayed when Option 3 is selected from the Data Migration menu and LOAD is to be used.

The text on the panel will reflect the Load Utility to be used. The default load utility is specified as a site option. A user option enables you to override this. (For more information, see the Common Elements Manual.) The Load utility is the default and, therefore displayed in the following figure.

-------------------------------- LOAD Process ---------------------------------
OPTION ===>                                                   SCROLL ===> PAGE 

  1  TABLE MAP           - Specify Table Map and Column Maps        
  2  PERFORM             - Specify LOAD Parameters and Perform LOAD 

Specify Data Set Name for Extract File and Control File: 
  Extract File DSN ===> 'FOPDEMO.SAMPLE.EXTRACT'
  Control File DSN ===> 'FOPDEMO.SAMPLE.CONTROL'

The available options are:

1 TABLE MAP

Specify the destination tables for each source table in the Load Process. By default, Move assumes that the destination table names are the same as the source table names in the Extract File. However, you must specify a default destination creator ID using this option.

When you specify a Table Map, you may also specify Column Maps for one or more destination tables. These maps allow you to specify on a column-by-column basis the source data for each destination column.

For more information about specifying Table Maps and Column Maps, see the Common Elements Manual. Note that only DB2 and Legacy table names are valid when specifying Table Maps for the Load Process. Views, synonyms, and aliases are not acceptable. (This is a DB2 restriction.)

2 PERFORM

Specify the parameters for the Load Process and perform.

Prior to selecting Option 1 or 2, specify:

Extract File DSN

The name of the Extract File containing the source data to be transformed into load format. This file must exist, must be a sequential data set, and must contain extract data.

Control File DSN

The name of the Control File that is to be used to accumulate information and statistics about the transformation of the Extract File to the load file format. The Control File keeps track of the rows that are discarded due to column mapping problems during the transformation process.

If the named file exists, the Load Process will overlay any previous data.

If the named file does not exist, you are prompted for allocation information and the file is created by Move for you. (See the Common Elements Manual for a description of the allocation prompts.)

Explicit Names

To specify the name of an Extract File or a Control File explicitly, use quotes to delimit the desired name; otherwise, it is prefixed based on the user option chosen.

Selection List

You can obtain a selection list of Extract Files or Control Files using the wild card characters * or % as the last character when specifying the name. A sample of the selection list displayed for Extract File or Control File data set names is provided in Figure 2.

If only one file matches the selection criteria, it is automatically assumed to be the selected name and a selection list is not provided.

Perform the Load

Select Option 2 PERFORM to specify the parameters and perform the process. Either the Specify LOAD Parameters and Execute panel or the Specify LOADPLUS Parameters and Execute panel is displayed, based upon the load utility that is used.