After you obtain workload index recommendations from the Workload
Index Advisor, you can implement them directly from this tool, or manually
on your DB2® for z/OS® subsystem.
Prerequisite: To run the
CREATE INDEX statements, you must have at least one of the following authorities:
- INDEX privilege on the table
- Ownership of the table
- DBADM for the database that contains the table
- SYSADM or SYSCTRL
To implement workload index recommendations:
- In the Project Navigator, under the appropriate
workload project folder, double-click Index Advisor. The Index Advisor page opens.
- In the Index Advisor Recommendations List,
select the recommendation that you want to implement.
- Optional: To experiment with different index scenarios,
click What-if analysis. Adjust the values in the What-If
Analysis Options page, and click OK. You can enter limits for disk space and the number of indexes for a
table, and you can suggest hypothetical indexes. When you return to the Workload
Index Advisor page, the estimated performance improvements and
disk space required values are updated.
- Perform one of the following tasks:
- To run the recommendations directly from the interface, click Run.
- To run the recommendations manually, click Show DDL.
Copy the recommendations into a file that you can print, or upload to your DB2 for z/OS subsystem,
and then run the CREATE INDEX statements later.