CURRENTDEGREE


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

CURRENTDEGREE.png 


Important

This option is meaningful only when direct access is not in effect. BMC AMI Unload ignores this option if you have specified any of the following options:

Operands

Value

Description

NONE

(default) BMC AMI Unload does not issue the SET CURRENT DEGREE command to Db2. For information about the SET CURRENT DEGREE command, see the appropriate IBM Db2 documentation.

Db2 uses the system Db2 installation default values. 

ANY

BMC AMI Unload issues the SET CURRENT DEGREE ANY command before running any dynamically ran SELECT statements. For information about the SET CURRENT DEGREE command, see the appropriate IBM Db2 documentation.

1

BMC AMI Unload runs SET CURRENT DEGREE = '1' before running any dynamically ran SELECT statements. For information about the SET CURRENT DEGREE command, see the appropriate IBM Db2 documentation.

 

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