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.

ENUMROWS


Specify this option to estimate the total number of rows that BMCSORT processes during the UNLOAD phase.

ENUMROWS.png

This option is meaningful only when DIRECT YES is in effect.

UNLOAD PLUS uses the ESIZE sort parameter to pass the value to BMCSORT. The default is ENUMROWS 0.

To allow BMCSORT to allocate sort work space dynamically, specify a value that is greater than 0 for ENUMROWS when you are unloading from one of the following sources:

  • A full or incremental image copy
  • A DSN1COPY sequential data set
  • An inline copy
  • A VSAM linear data set

Restriction

UNLOAD PLUS ignores this option when DIRECT NO is in effect.

Partitioned table space

If you are unloading from a partitioned table space, we recommend that you do not use ENUMROWS. When UNLOAD PLUS multitasks the sorting of a partitioned table space, UNLOAD PLUS divides the ENUMROWS option by the maximum number of concurrent tasks.

Multiple table spaces

When UNLOAD PLUS multitasks the sorting of multiple table spaces, the number that you specify with ENUMROWS applies to each of those table spaces. To unload multiple table spaces, therefore, base your estimate on the table space that contains the greatest number of rows that UNLOAD PLUS will sort.

 

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