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

Data and control cards from UNLOAD PLUS

You can use the combination of UNLOAD PLUS and LOADPLUS to migrate data from one table to another.

BMC provides two high-performance migration methods, migrating the data in internal BMC format or in a standard Db2 format:

  • To migrate data in internal BMC format (which is the most efficient method and provides the best performance), specify FORMAT BMCLOAD in UNLOAD PLUS to unload the data, and FORMAT BMCUNLOAD in LOADPLUS to reload the data.
  • To migrate data in a standard Db2 format, use one of the other FORMAT options in UNLOAD PLUS (such as FORMAT INTERNAL) to unload the data. Then reload the data with LOADPLUS, using the control cards that UNLOAD PLUS generated.

Each method has certain requirements and considerations. For more information, see the following topics:

Related topic

Sizing-and-performance

 

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