Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.2 - Release Notes

Deploy Plan Guides

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To deploy a plan guide

  1. Select the SQL Details tab in the main window.
  2. Select a Plan Control Session.

  3. Click and select the alternative from the Select a Plan to Deploy list.

    Note: You can also right-click the alternative you want to deploy as a plan guide in the Alternatives pane and select Deploy Plan Guide.

  4. Review the following for additional information:

    Deploy Description

    Select a plan to deploy

    		 Click and select an execution plan alternative to deploy.
    Performance Comparison Description

    Mark the plan as

    Review the following for additional information:

    • Enabled—Select whether to enable or disable this plan.
    • Fixed—Select whether to deploy this plan as fixed or non-fixed.
    • Not Auto-Purged—Select whether to auto-purge when it is not used.

    Plan name

    		 Enter a name for the plan.

    Description

    		 Enter a description for this plan.

  5. Click .

  

Related Topics  

 

Generate Execution Plan Alternatives

Execute Execution Plan Alternatives

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating