CURRENTDEGREE

Related topics

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

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:

On the UNLOAD command:
- DIRECT YES
- DIRECT AUTO and BMC AMI Unload has not encountered any conditions that cause it to switch to DIRECT NO.
On the UNLD command:
- MODE(DIRECT)
- MODE(AUTO) and BMC AMI Unload has not encountered any conditions that cause it to switch to MODE(DB2SQL)

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 Unloadissues 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 Unloadruns 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.

CURRENTDEGREE

Operands

BMC AMI Unload for Db2 13.1

On this page