Space announcement


This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.


    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.

Was this page helpful? Yes No Submitting... Thank you