Restoring a previous access plan

If the access plan has regressed and you are using DB2 for z/OS Version 9 or higher, you can revert to a previously stored access plan.

Before you begin

Procedure

  1. In the Manage and Tune page of the workflow assistant, select a workload that contains the access plan comparison results.
  2. Click the View Comparison Result icon and drill down to review the Packages section.
  3. Select the source or target package with the access plan that regressed and click the Plan Management icon.

Feedback