MAXTHREADS

Use the MAXTHREADS option to specify the maximum number of processing threads that Optim™ High Performance Unload can use.

MAXTHREADS

You can specify this parameter to limit the processing usage for unloads that involve small tables. Setting a lower value for this parameter will allow Optim High Performance Unload to unload several tables at the same time using less processing threads.

Syntax

MAXTHREADS n

Variable

n

Specify an integer value equal to the maximum number of threads. The minimum value for this variable is 1 and the maximum value is equal to the number of processors.

Default

None.

Example

For example, if you have 4 available processors and you want to unload TABLE1, TABLE2, and TABLE3, with the option MAXTHREADS 1, Optim High Performance Unload processes all the three tables at the same time with one processing thread for each.