REPLACE

REPLACE tells LOADPLUS to replace any existing data in the table space (not only the data in the tables or partitions that you specify in the INTO TABLE option).

Related topic

Basic-LOADPLUS-processing-options

REPLACE.png

LOADPLUS deletes the existing data in the table space before loading.

LOADPLUS converts data that is in basic row format to reordered row format. However, if the table contains a VALIDPROC or EDITPROC, LOADPLUS loads the data according to the existing row format on the table space.

When invoking DSNUTILB, LOADPLUS passes this option to the IBM Db2 LOAD utility for processing.

Restrictions

LOAD REPLACE has the following restrictions:

  • If you specify the REPLACE option, you cannot specify the PART n REPLACE or TABLE tableName REPLACE option.
  • LOADPLUS terminates if you specify REPLACE for a system-period temporal table that is enabled for versioning. 

KEEPDICTIONARY

This option tells LOADPLUS whether to keep the existing compression dictionary. If you specify KEEPDICTIONARY without a value, LOADPLUS assumes KEEPDICTIONARY YES. For details about when LOADPLUS builds and keeps a dictionary, as well as additional considerations when using compression, see Considerations-for-table-space-compression.

LOADPLUS also provides KEEPDICTIONARY support at the partition level. For information about how to use the PART REPLACE options, see PART.

Restrictions

The following restrictions apply to the KEEPDICTIONARY option:

  • The KEEPDICTIONARY option is valid only if the table space that you are loading has the COMPRESS YES attribute.
  • If a table space is compressed and a load job would convert the row format from BRF to RRF, LOADPLUS builds a new dictionary except when both of the following options are in effect:
    • The value of the LOADPLUS KEEPDICTIONARY option is YES.
    • The value of the DB2 subsystem parameter HONOR_KEEPDICTIONARY is YES.

Specifying the default

You can specify the default for the KEEPDICTIONARY option in your installation options module by using the KEEPDICTIONARY installation option. LOADPLUS was shipped with a default value of NO for this option. The command option overrides the default that is in the installation options module.

YES

If you specify KEEPDICTIONARY YES, LOADPLUS keeps the existing compression dictionary. If a dictionary already exists, LOADPLUS uses it for compression. If a dictionary does not exist, LOADPLUS builds one in the PRELOAD phase or the COMBINED phase. After completely building the dictionary, LOADPLUS compresses the data.

When invoking DSNUTILB,

  • For an SQLAPPLY load, LOADPLUS ignores this option.
  • Otherwise, LOADPLUS passes the value of this option to the IBM Db2 LOAD utility as KEEPDICTIONARY.

NO

If you specify KEEPDICTIONARY NO, LOADPLUS builds a new compression dictionary. LOADPLUS builds the dictionary in the PRELOAD phase or the COMBINED phase. After completely building the dictionary, LOADPLUS compresses the data.

Restriction

When invoking DSNUTILB, LOADPLUS ignores this option.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*