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.

INTERVAL

The INTERVAL option allows you to unload a sample of data, rather than all rows that meet the selection criteria.

INTERVAL.png

The default is INTERVAL 0. The INTERVAL integer defines the interval of the selected rows that UNLOAD PLUS unloads. For example, INTERVAL 10 means that UNLOAD PLUS unloads every tenth row that it selects from each table or partition of the table space.

Important

When unloading from a partitioned table space using DIRECT NO, INTERVAL functions as if the table space were nonpartitioned.

Related topic

Basic-processing-options

 

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