Manage section

Use this section to create and manage query workloads.

This section contains the following pages.

Manage and Tune Workloads page
On this page, you can view the list of all of the query workloads that you have access to on the connected DB2® for z/OS® subsystem. You can check the status of each workload and carry out these tasks:
  • Run advisors on a workload
  • View recommendations for a workload that you ran advisors on in the past
  • Open the Statements page for a workload
  • Open the Schedule page for a workload
  • Open the History page for a workload
  • Capture information about the environment of a workload
Statements page
On this page, you can view a list of SQL statements that are in the currently selected workload. You can also carry out these tasks:
  • Add statements through a wizard
  • Add statements by typing or pasting in a window
  • Create a new workload as a subset of the statements in the current workload
  • Run the single-query tools and advisors on a statement in the current workload
  • Open the Schedule page for the workload
  • Open the History page for the workload
Schedule page
On this page, you can view a list of scheduled tasks that you ran or are running on the currently selected workload. You can also carry out these tasks:
  • Schedule a task to add statements to the workload
  • Schedule a task to consolidate EXPLAIN information for the workload
  • Schedule a task to gather EXPLAIN information for the workload
  • Schedule a task to run the workload advisors
  • Open the Statements page for the workload
  • Open the History page for the workload
History page
On this page, you can view a list of events that modified the currently selected workload, such as when the workload was created, when EXPLAIN data was collected for it, and when it was updated.

Feedback