PlanName

The PlanName parameter specifies the Db2 plan that the High-speed Apply Engine uses during apply processing.

Important

High-speed Apply Engine does not use this plan to access the Db2 catalog or the restart tables. To specify the plan name that accesses the restart tables, use the PlanName parameter in the [StartUp] section (PlanName-parameter).

Related topics

Bind-parameters

Db2-authorizations-for-plans-packages-and-collections

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[Bind]

Abbreviation

None

Required?

No

Valid values

1 to 8 alphanumeric characters.

(The first character must be alphabetic.)

Default value

Generated plan name, based on the value of PlanPrefix parameter and the apply request ID

Usage

Specify the name of a Db2 plan that High-speed Apply Engine can use to bind packages for the target tables. If you specify both PlanName and PlanPrefix, High-speed Apply Engine uses the value that you specify for PlanName.

To prevent potential naming conflicts, do not run concurrent jobs that specify the same Db2 application plan.

If you do not specify a value for the CollectionID parameter, High-speed Apply Engine uses the PlanName as the collection ID for any packages that it creates. For more information, see CollectionID and DB2 authorizations.

If the value of BindAction is Use, High-speed Apply Engine uses (but does not bind) the plan specified by PlanName. For more information, see BindAction.

 

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