Information
Limited support BMC 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.

SORTNUM


The SORTNUM option affects the number of sort work files allocated when BMCSORT is allocating your sort work files dynamically.

SORTNUM.png

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

You can specify any integer value from 0 through 255.

The following table describes the action that BMCSORT takes for each value that you can specify for this option. The table also provides any additional considerations for these values.


SORTNUM values

Value

Description

Additional considerations

0

BMCSORT honors the value of the third parameter of the BMCSORT DYNALOC installation option. (This parameter tells BMCSORT whether to dynamically allocate sort work files.)

For more information about how this parameter affects dynamic allocation, see Dynamically allocating SORTWK data sets. For more information about this parameter, see DYNALOC-installation-option.

1-32

BMCSORT dynamically allocates the number of sort work files that it needs, up to 32 minus any sort work files that are allocated in your JCL. This number is per task

None

33-255

BMCSORT dynamically allocates the number of sort work files that it needs, up to the number that you specify minus any sort work files that are allocated in your JCL. This number is per task.

In this case, we strongly recommend that you change the second value of the SMCORE installation option to 384K.

 If the value of the third parameter in the BMCSORT DYNALOC installation option is OFF, specifying a value greater than 0 for the SORTNUM option turns BMCSORT dynamic allocation on, and BMCSORT allocates sort work files as needed.

The sort work files that BMCSORT allocates dynamically might be used in one of the following circumstances:

  • If you do not specify any SORTWK DD statements in your JCL
  • In addition to any SORTWK data sets that you specify in your JCL if BMCSORT determines that there is a need for additional data sets

For information about circumstances under which BMCSORT allocates your sort work files dynamically, see SORTWK-data-sets.

If you depend on BMCSORT to dynamically allocate your sort work data sets, we recommend that you also specify the ENUMROWS option.

Restriction

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

Specifying the default

You can specify the default for the SORTNUM command option in your installation options module by using the SORTNUM installation option. UNLOAD PLUS was shipped with a value of 32. The command option overrides the default that is in the installation options module.

 

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

UNLOAD PLUS for DB2 11.2