Query Explorer
Use the query explorer to view a list of queries and folders.
Folders
can contain other folders and are a way of organizing and grouping
queries.
Queries are a definition of resources to be searched for, and defined
using
the Query window.

To create a new query use the toolbar menu options File > New > New Query which
will open the Query window where you
enter the kind of resources to you want to find and interactions
to search.

To create a new folder use the toolbar menu option File > New > New Folder. This
creates a folder called New Folder which
you can rename by overtyping.

You can also us the New option on the pop-up menu to perform actions on
a query.

Copy, will copy the definition of the query to the clipboard, which you
can paste into either the same folder or a different folder in the
Query
window. If you paste the clipboard contents into a text editor
you
will see the raw SQL strings that are run against the DB2 tables, a
feature
which is useful for users who have their own ways of executing SQL and
collecting results.
The Run option executes the query and the results are shown in the Resources window.
When the Resources window shows the result of running a query you can
save
the resources to be recorded against the query. Use the toolbar File > Save
menu option. For example, if the query in the screen dump
above is
run, the May have affinities query
is executed and the results are shown in the Resources window.

If you select the menu option File >
Save brings up the Save query results window box in which you enter
a relevant name to record against the results, as shown in the screen
dump
below:

The results for a query shown in the Query window are children of the
query.
The screen dump below shows the
Before Fix 123456 applied data
beneath the May have affinities query.
The date and time are appended to the name entered in the
Save query results window so you can view information about why and
when
the query was run.

The copy option on the pop-up menu for a set of query results will take
all of the query data and place it into the clipboard, then you can
paste
it into a spreadsheet, or other tool, to do additional analysis as
required.
The run option on the pop-up menu for a set of query results will open
the saved data in the Resources
window. After opening different query results, for the same
query, run on
different dates. You can use the Compare
Resources window to see what has changed and build up a picture of
change over time.
Query results can be individually deleted, if a query is deleted then
all
of its results are deleted as well.