Deploying recommended access paths

Edit online

Use the following procedure to implement access paths that have been recommended by IBM® Z Database Assistant.

Before you begin

Exploration must be completed before deploying access path recommendations. Explorations can either be scheduled, as described in Scheduling SQL optimization tasks, or started manually, as described in Manually starting an exploration. Once an exploration is finished, the status for the statement is Complete. The exploration can also be found in the Past recommendations tab with the status Ready for review.

About this task

After the exploration process is complete and IBM Z Database Assistant has determined either that a better access path exists for the statement, you can analyze the results and choose whether to take the recommended action.

Procedure

To analyze an access path recommendation:

  1. After exploration, open to the exploration details by clicking View details in the Actions column.

    By default, if there are access path recommendations, the Access path tab is open.

  2. Check the status of the recommendation in the top, right corner of the Access path summary pane.
    Statuses include:
    • Pending
    • Deployed
    • Skipped
  3. Read the recommendation and the AI explanation of the recommendation, if one is available, in the Access path summary pane.
  4. Analyze the recommendations from exploration in the Access path comparison pane.
    The access path comparison table shows various parameters related to the most recent exploration for the statement. This section contains data about various access path plans that can help you to determine whether or not to deploy a recommendation.
    IBM Z Database Assistant highlights the plan that yields the best results in terms of CPU time saving and elapsed time saving in green to indicate it is the recommended access path.
  5. Analyze further details about each plan in the Plan details pane.

To deploy a recommended access path:

  1. Click Deploy in the top, right corner of the Access path summary pane.
    The Deploy recommendation dialog opens.
  2. Select the Rebind packages checkbox to rebind the package containing the statement. This is necessary for the new access path to take effect.
    The checkbox is selected by default. If you do not choose this option, you must perform a rebind separately.
  3. Select the Deploy immediately checkbox to immediately complete the steps necessary to deploy the access path.
    The checkbox is selected by default. If you do not choose this option, the Deployment scheduler appears.
    1. If you choose not to resolve immediately, specify the following values:
      Deploy label
      An optional user-defined descriptor for a particular regression resolution schedule.
      Deploy frequency
      The rate at which the deployment will occur, either Daily, Weekly, or Once.
      Kick-off date and time
      The date and time when the regression resolution will begin.
      Max end date and time
      The date and time at which a regression resolution will end if it has not finished already.
  4. Click Deploy to save your changes and deploy the access path recommendation.
    The status to the right of the Deploy button changes to Deployed.

To skip a recommended access path:

  1. Click Skip in the top, right corner of the Access path summary pane.
  2. Click Confirm to confirm you want to skip the recommendation.
    The status beside the Deploy button changes to Skipped.