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 UNLOAD PLUS for DB2 13.1.

Unloading data with FORMAT BMCLOAD

This topic describes how to use FORMAT BMCLOAD for high-speed data migration using UNLOAD PLUS and LOADPLUS .

For an example of this feature, see Example 19 — Unloading data to LOADPLUS.

To unload data that you plan to reload by using LOADPLUS

  1. Ensure that the table that you are unloading meets the requirements specified in Table structure considerations for FORMAT BMCLOAD.
  2. Specify FORMAT BMCLOAD with your UNLOAD command.

  3. Specify CNTLCARDS BMCLOAD with your UNLOAD command.

    Important

    If you specify or default to any other CNTLCARDS option, UNLOAD PLUS changes the value to BMCLOAD.

  4. If you are unloading an identity column that is defined as GENERATED ALWAYS, include the string 'IDENTITYOVERRIDE YES' on your CNTLCARDS BMCLOAD option.Additionally, you must edit your generated LOAD control cards to add a field specification for the identity column.
  5. If you are unloading a system-period temporal table, include the string 'PERIODOVERRIDE TRANSIDOVERRIDE' on your INTO option.
  6. (recommended) Dynamically allocate your SYSREC data set.
  7. Ensure that your UNLOAD command does not contain any of the invalid or restricted commands described in Command options that are incompatible with FORMAT BMCLOAD.
  8. Ensure that your job meets additional requirements described in Additional restrictions and considerations for FORMAT BMCLOAD.
  9. After running your unload job, edit generated LOAD control cards as needed.For example, if you are unloading columns that are defined as GENERATED ALWAYS, you must add field specifications for those columns.

Related topic

Data-migration-using-LOADPLUS-FORMAT-BMCLOAD

 

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