PublicPlan

The PublicPlan parameter determines whether the High-speed Apply Engine grants the authority to run High-speed Apply Engine (execute against the base plan) to PUBLIC.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[StartUp]

Abbreviation

None

Required?

No

Valid values

Yes or No

Default value

Yes

Related topic

StartUp-parameters

DB2 authorizations

Considerations

Usage

Use this option to avoid specific grants of authority to individual users that run High-speed Apply Engine. Specify one of the following values for the PublicPlan parameter:

  • Specify a value of Yes (the default value) to direct High-speed Apply Engine to grant EXECUTE authority on the base plan to PUBLIC. All users have authority to run High-speed Apply Engine.
  • Specify a value of No to prevent High-speed Apply Engine from granting EXECUTE authority on the base plan to PUBLIC. If you specify No, you must grant EXECUTE authority on the base plan to all specific users that run High-speed Apply Engine.

Be aware of the following points about the PublicPlan parameter and the High-speed Apply Engine base plan:

  • In most cases, we recommend accepting the default value of Yes. You can specify this parameter in the installation options module during the install process or you can specify it in the configuration file.
  • The name of the High-speed Apply Engine base plan is determined by the PlanName parameter (PlanName-parameter).

 

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