LOAD Utility Options panel

Panel and field definitions

  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                Load Utility Options              Global Settings


 Utility Options:
    Enter "/" to select option
       Preformat unused pages
    /  Log changes                --NO-->     Do not set COPY pending flag
       Use IEEE floating point
       Allow substitution chars
       Enforce constraints
       Resume (append new data)   --NO-->     Replace existing data
                                              Reuse existing dataset
       Build indexes in parallel
        Number of index keys  10       

 CCSID Values:
    SBCS data . . . . . . . . 0         (0 for installation default)
    Mixed DBCS data . . . . . 0         (0 for installation default)
    DBCS data . . . . . . . . 0         (0 for installation default) 

 Discarded Records:
    Maximum discards  . . . . 0                 (0 means no limit)

 Encoding Scheme
 1 1. EBCDIC
   2. ASCII
   3. UNICODE
  
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Preformat unused pages

Indicates whether the allocated file space for a table is preformatted to enable quicker INSERT processing. The default is not selected.

Log changes

Indicates whether Db2® logs details in the Db2® log of the rows that are loaded. The default is selected.

Do not set COPY pending flag

If Log changes is not selected, indicates whether Db2® is not to set the table space in COPY pending status. The default is not selected.

Use IEEE floating point

Indicates whether floating-point numbers are in IEEE Binary Floating Point (BFP) format. The default is not selected.

Allow substitution chars

Indicates whether the LOAD utility accepts substitution characters in a string. The default is not selected.

Enforce constraints

Indicates whether the LOAD utility enforces check constraints and referential constraints. The default is selected.

Resume (append new data)

Indicates whether records are loaded into an empty or non-empty table space, without existing data being deleted. The default is not selected.

Replace existing data

If Resume (append new data) is not selected, indicates whether the table space and all its indexes are reset to empty before records are loaded. The default is not selected.

Reuse existing dataset

If Resume (append new data) is selected, indicates whether the LOAD utility logically resets and reuses Db2-managed data sets without deleting and redefining them. The default is not selected.

Build indexes in parallel

Indicates whether index keys are sorted in parallel during LOAD. The default is not selected.

Number of index keys

An estimated number of index keys to sort. The default is 10.

SBCS data

The coded character set for SBCS data in the input file. The default is 0.

Mixed DBCS data

The coded character set for mixed DBCS data in the input file. The default is 0.

DBCS data

The coded character set for DBCS data in the input file. The default is 0.

Maximum discards

The maximum number of discarded records allowed before LOAD abends. The default is 0.

Note: FM/Db2 does not attempt to validate every possible combination of load utility options. In particular, some combinations of options fail given the current state of the Db2® object being loaded. This can mean that the Db2® load utility job will fail if an invalid combination of options has been specified. If this occurs examine the failing messages for the Db2® LOAD utility job and respond accordingly.

Encoding Scheme

Indicates the encoding scheme for the data to be loaded. The encoding scheme applies to character and graphic data only.

1. EBCDIC

The data is encoded by using an EBCDIC CCSID. This is the default.

2. ASCII

The data is encoded by using an ASCII CCSID.

3. UNICODE

The data is encoded in unicode (either CCSID 1208 or CCSID 1200).