Default language.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

REPLACE (INTO TABLE option)

Specify REPLACE on the INTO TABLE statement to reset the specified partitions to empty before loading any data.

RESUME.png

You can use REPLACE and RESUME YES in a single BMC AMI Load step by specifying multiple INTO TABLE statements. For an example, see Replacing-some-partitions-adding-data-to-some-partitions-and-leaving-remaining-partitions-available.

If you specify LOAD RESUME YES SHRLEVEL CHANGE and a mix of PART REPLACE and PART RESUME YES, BMC AMI Load stops the RESUME YES partitions during the load.

Related topics

INTO-TABLE-options

Syntax-diagrams-for-BMC-AMI-Load

REPLACE 

 

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