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 LOADPLUS for DB2 13.1.

SORTNUM


The SORTNUM option affects the allocation of sort work files in the following cases.

SORTNUM.png

You can specify any integer value from 0 through 255.

DSNUTILB load jobs

When invoking DSNUTILB, LOADPLUS passes this option to the IBM Db2 LOAD utility as the number of sort work files to allocate dynamically. For this type of load, the value must be 2 or greater.

All other load jobs

This value is in effect when BMCSORT is allocating your sort work files dynamically.

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.

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 SORTWK-data-sets-in-LOADPLUS.

1-32

BMCSORT dynamically allocates the number of sort work files that it needs, up to 32 minus any preallocated sort work files. This number is per sort task.

Preallocated sort work files include sort work files that are allocated in your JCL and any sort work files that LOADPLUS dynamically allocates.

33-255

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

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.

For information about when BMCSORT allocates your sort work files dynamically, see SORTWK-data-sets-in-LOADPLUS.

Specifying the default

You can specify the default for the SORTNUM command option in your installation options module by using the SORTNUM installation option. LOADPLUS 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*

LOADPLUS for DB2 11.2