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.