Fast unload

When you specify to use the UNLOAD PLUS and LOADPLUS utilities, the utilities can quickly unload data from one table and load it into another table that has a similar structure.

When you use a migrate-type work ID, you can copy data in one Db2 table or Db2 subsystem and move it to another table or Db2 subsystem. When you use an alter-type work ID, you can make changes to a table that do not affect the structure of the table, such as changing the table space name.

To enable this feature, the BMCFASTL installation option must be set to Y. If BMCFASTL is set to N, you must manually change the NOBMCFASTLOAD keyword to BMCFASTLOAD in the ALUIN input stream.

When the Alter- or migrate-type work ID is analyzed, Analysis inserts the -BMCD command with the FORMAT BMCLOAD control card into the worklist.

Important

You can use the fast unload feature to unload and load objects that are defined as Unicode. The fast unload feature requires the CCSID definition of the table space to match the default CCSID definition of the subsystem that is specified in the DSNHDECP load module. If the definitions do not match, the product does not use the feature to unload and load data.

You cannot use the fast unload feature (BMCFASTLOAD ALUIN keyword) with spanned records.

Related topic

The-BMC-UNLOAD-PLUS-utility

 

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