MAXCONNECT

MAXCONNECT specifies the maximum number of tasks that UNLOAD PLUS can execute concurrently when unloading data using Db2 dynamic SQL.

Related topic

Basic-processing-options

MAXCONNECT.png

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

When unloading data using Db2 dynamic SQL, UNLOAD PLUS executes one SELECT statement per task. Each task uses a batch thread to process a SELECT statement. You can use MAXCONNECT to limit the number of batch threads that UNLOAD PLUS uses during the UNLOAD phase.

Considerations

The following considerations apply to MAXCONNECT:

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

Specifying the default

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