+CONNECTALL

Use this parameter to tell BMC AMI Unload to connect all table space partitions to the BMC AMI Utilities Subsystem started task, also known as CDBSS when unloading selected partitions.

GUID-C80AFE16-6C9F-4D46-B14B-8EE6CCF8AA88-low.png

Related topic

BMC-AMI-Unload-parameters-ULDPARMS-DD 

BMC AMI Unload is an online product and the CDBSS tracks changes during unloads. When BMC AMI Unload runs an unload on a subset of partitions, BMC AMI Unload tracks the changes only in those partitions.

It is most efficient to track only changes for the subset of partitions that you are unloading using +CONNECTALL(NO). However, this prevents BMC AMI Unload from unloading separate or overlapping partitions concurrently in a separate unload job or statement.

Use +CONNECTALL(YES) when you expect to run multiple unload jobs or statements on the same partitioned table simultaneously and you are not unloading all partitions.

Operands

YES or Y

Connects all partitions even if only a subset of partitions being unloaded.

NO or N

Connects only the partitions selected for unloading.

This is the default option.

In the following example, track changes for all partitions in preparation for concurrent unloads on the table:

+CONNECTALL(Y)

In the following example, track changes only for the specific partitions that you are unloading:

+CONNECTALL(N)

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.


 

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