Skip to Content

MAXSORTS

Use this option to specify the maximum number of tasks that UNLOAD PLUS can execute concurrently.

Related topic

Basic processing options

 

MAXSORTS.png

This option is meaningful only when executing multiple tasks to unload a partitioned table space or multiple table spaces.

Restricting the number of concurrent tasks is critical when BMCSORT is invoked because sorting consumes a significant amount of system resources.

Error
Warning

Too many concurrent tasks to a single output data set can degrade performance. When you use a single SELECT statement to unload a partitioned table space, or when you are unloading from multiple table spaces, use multiple output data sets or use the MAXSORTS option to limit the number of concurrent tasks and reduce contention. For the ramifications of using the MAXSORTS option, see  Performance considerations for sort processing options.

Considerations

The following considerations apply to the MAXSORTS option:

  • When unloading to a BatchPipes file, you must set MAXSORTS to 1.
  • UNLOAD PLUS ignores this option when DIRECT NO is in effect.

Specifying the default

You can specify the default for the MAXSORTS command option in your installation options module by using the SMAX installation option. UNLOAD PLUS was shipped with a default value of 16 for this option. 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 13.1