CURRENTDEGREE

You can use the CURRENTDEGREE keyword to specify that you want Db2 to attempt to use parallelism.

Related topic

Basic-processing-options

CURRENTDEGREE.png

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

Specifying CURRENTDEGREE ANY or CURRENTDEGREE 1 causes UNLOAD PLUS to issue the SET CURRENT DEGREE command before executing any dynamically executed SELECT statements. For more information about the SET CURRENT DEGREE command, see the appropriate IBM Db2 documentation.

Restriction

UNLOAD PLUS ignores this option when DIRECT YES is in effect.

Specifying the default

You can specify the default for the CURRENTDEGREE command option in your installation options module by using the CURRENTDEGREE installation option. UNLOAD PLUS was shipped with a default value of NONE for this option. The command option overrides the default that is in the installation options module.

NONE

Specify NONE if you do not want UNLOAD PLUS to issue the SET CURRENT DEGREE command to Db2. Db2 uses the system Db2 installation default values.

ANY

Specify ANY if you want UNLOAD PLUS to issue SET CURRENT DEGREE ANY before executing any dynamically executed SELECT statements.

1

Specify 1 if you want UNLOAD PLUS to issue SET CURRENT DEGREE 1 before executing any dynamically executed SELECT statements.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*