Authorities and privileges required for analyzing and tuning query workloads
Your authorization ID must have specific authorities and privileges to perform certain workload tuning tasks from the .
Authorities and privileges required for capturing SQL statements for workloads
These authorities and privileges are required for capturing SQL statements from different sources to create query workloads.
Authorities and privileges required for managing workloads
These authorities and privileges are required for managing SQL workloads.
Authorities and privileges for running workload advisors
These authorities and privileges are required for running the workload advisors and implementing the recommendations of the Workload Statistics Advisor and the Workload Index Advisor.
Related concepts
Creating query workloads
Testing packages of static SQL for performance regressions
Related tasks
General steps for tuning query workloads
Verifying the configuration of a subsystem for query-workload tuning
Importing query workloads from .zip files that the Optim Query Tuner client exported or from XML files
Collecting EXPLAIN information about the statements in query workloads
Getting recommendations for tuning query workloads
Generating table reports for query workloads
Sharing recommendations from the workload advisors
Running analysis tools and advisors on single SQL statements that are in query workloads
Adding SQL statements to query workloads
Consolidating EXPLAIN information for query workloads
Monitoring query workloads
Gathering information for IBM Support about the environments in which query workloads run
Recreating workload environments on other subsystems
Creating Query Tuner projects
Related reference
Workflow assistant for query tuning
XML files that use the Optim Query Workload Tuner schema
Feedback