Trace Query dialog and view
You can use the Trace Query view (ITAQUERY) to create and execute a query against the trace data in a trace data set. However, for more robust queries, BMC also offers a separate trace query dialog. This topic explains both the dialog and the view.
Trace query dialog
You can hyperlink to the trace query dialog from the ITALISTD view. (Various trace views have Overview/Query fields that hyperlink to ITALISTD.) From this dialog, you can build a simple or complex query to drill down to a subset of transactions that you want to analyze more closely.
| |
| End Date 17NOV2015 (mmdddyyyy) |
| End Time 06:15 (hh:mm) |
| Duration All (nnnnu u=(I)ntvls,(M)inutes,(H)ours,(D)ays,(W)eeks |
| Add Filter Operators , such as = 'XYZ', to use a filter field |
| PSB Name |
| Tran Name |
| Type TPI,BMP,CON,MPP,MDP,NDP,FPU,DBT,ODB,JMP,JBP |
| Input Type APPC,LTERM,OTMA,MSGSW |
| User LTERM/TPIPE |
| IMS Connect OTMA Userid |
| Region Name Class |
| ABEND Code WrkLoad Name |
| Initial values are approximate maximums for period. Change ** to >= |
| to find records with these maximums. Enter other parameters, such as |
| >.001, <.001, or BETW .001 AND .002, to locate other records |
| RESP Time **0.226500 ELAP Time **0.182000 |
| InputQ Time **0.156700 -%Application **19.37 |
| Total CPU **0.001770 DB2 CPU **0.000000 |
| DL/I CPU **0.001528 Non I/O wait **0.054639 |
| DL/I calls |
| Total calls **3 Longest DC **0.000000 |
| DB Calls **1 Longest DB **0.000000 |
| DB Time **0.001318 -Time per call **0.000948 |
| StatCD Exc **0.000000 I/O count **1.68 |
| ESS calls |
| Total ESS **0 Longest ESS **0.000000 |
| ESS time **0.000000 -Time per call **0.000000 |
| RetCodes Exc **0.000000 |
| Calls >= Thresholds |
| DC calls **0.000000 DB or ESS calls **0.000000 |
| % of total **0.00 % of total **0.00 |
| Edit query filters prior to invoking ITASUMZ view NO |
| |
| END To invoke ITASUMZ view with filters |
| CANCEL to quit the dialog |
| HELP to view related help |
| |
| |
| |
| COMMAND ===> SCROLL ===> PAGE |
|-----------------------------------------------------------------------------|
When you build a query on the dialog, these guidelines apply:
- The starting values are just the maximums found in the trace. You can enter any values you choose. For example, >=0.0708729 in the Longest DB field to find those with DB calls >= to that value.
- You can set query parameters for any of the trace data fields to find just the BMPs or transactions you are interested in querying.
You can include filter operators via the MainView Infrastructure QWHERE command.
- Some pre-populated fields begin with **. The value following ** represents the approximate maximum value for that particular trace measurement. To use that field in your query, remove the ** and either accept the displayed value or replace it with your own value. Leaving the field as is (with ** at the beginning) omits that field from the query.
- When you finish, pressing the END key executes the query and displays your selected transaction in the ITASUMZ field.
Trace Query view
You can also use the Trace Query view (ITAQUERY) to create and execute a query by selecting the trace ID and the data set name ID (or token) in the view's TraceID, DsnID field (shown in Trace Query view (ITAQUERY)). The data retrieved is displayed in the ITASUMZ view.
In the COMMAND field, you can enter R to execute your query request or Q to modify the QWHERE filter that the query uses. You can use the QWHERE filter to create complex expressions and use other trace filter parameters. You can specify other trace query parameters for trace ID, data set ID, transaction code, and PSB name, and you can specify thresholds for response and elapsed times.
COMMAND ===> SCROLL ===> HALF
CURR WIN ===> 1 ALT WIN ===>
W1 =ITAQUERY==========IMSxxx===*========12OCT2015==16:46:31====MVIMS====D====1
Trace Query Request
Command.......(required) R- Run, Q- Edit QWHERE
TraceID,DsnID (required) ABR3,32
Time Period............. 21MAY2015 12:09 1I Update with TIME command
Workload Name........... *
Transaction Code........ *
PSB Name................ *
Response Time >= 1.0
Elapsed Time >= 0.5
No hyperlinks are available on the view.
Related topic