You create queries to search resources using the Query Editor.
You can specify two main criteria in a query: the parts of an interaction that you want to see, and the interactions that you want to include.
The parts of an interaction to see
When you select the type of resource that you want to query, you can choose the information that you want to be shown in the tree structure of the Show Resources view when the query runs. The following screen capture shows the Create IMS™ query which includes a menu that lists the types of resources that you can query. You can select multiple resources.
To add a resource to the
tree, use the green plus button above the
tree structure. To remove a resource, use the red cross
button while the resource is selected. You can move up and
down the tree using the down arrow
and up arrow
buttons.
Interactions to include
To further refine the query for the resources
that you have chosen, use the Filter results panel. You can create
multiple expression filters and each resource is provided with a set
of filter possibilities. To add filters use the green plus button above the table of all expressions. To remove a filter,
use the red cross
button while the expression is selected.
The following example shows a CICS® Query called CICS Query Programs D that shows the Resource type, at the top of the tree, followed by Resource name, Transaction, and Program, where the only programs shown in the query results begin with D as requested in the filter results panel.
The result of running the CICS Query Programs D is displayed in the Show Resources view, in the order specified by the query.
If an expression does not have a choice entered against it in the Filter results panel, of the Query Editor that expression is removed from the query, is not stored, and is not retrieved when the query is edited the next time.
You can add an expression with a suitable value in the Filter results panel of the Query Editor when you next edit a query.
If the column name you want to filter has a name relationship with another column, that is they have the same name, use the radio button to select either the column of the same name or to select a value that to enter in the following panel. The following example shows the Filter panels when there is a single column name relationship:
If the column name you chose to filter the results has a name relationship with more than one other column name, they are listed in a menu as shown in the following example:
You can create a query to further interrogate the particular user ID for a given run of a transaction.
You can create a scanner query to compare CICS collector and scanner data to make sure that the CICS IA data that is captured at run time and the data captured during the batch scanner are consistent.
In version 3.2.0.1 of the CICS IA plug-in new resource types are available to add to the Show and Filter parts of a query. These are Channel, Commarea, Object Length, User Data 1, User Data 2 and, User Data 3. A new resource type is also available specifically for the Show part of a query called Collection ID.
When running the query in the previous screen capture only resources in the scope of the current Collection ID are displayed in the Shown Resources view.