n_update_threads

Default: 0
Range: 0 – 16
Applies to: SQL Server (see note), Oracle, and DB2 Clients

Use this parameter to specify the number of update threads to be used. The update threads are responsible for executing SQL to update the user table. If you have multiple processors and disk arrays, setting this parameter to a high value will increase the update processing speed at the expense of additional memory. Avoid setting this parameter to 1, as this will effectively pass off all updates to the single worker thread, when executing them directly would be preferable.

Note: This parameter requires the use of SQL Native Client in ODBC. The SQL Server driver doesn’t support MARS, which is required for multithreaded updates. If MARS cannot be enabled, the client automatically reverts to using single-threaded updates.