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.

Related topic

Sizing-and-performance

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

 

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