(DBA) Trace QMF and ad hoc SQL usage
The following trace request provides the SQL statement text, EXPLAIN data, and the row statistics of the QMF queries. Only long-running queries are kept for later analysis.
Option | Use |
|---|---|
TYPE=DETAIL | Relatively low overhead |
START=09:00:00 | Cover main morning activity |
STOP=11:30:00 | Stop at lunch time |
WRAP=YES | Keep the latest occurrences in the buffer |
DB2PLAN=QMF310 | Select QMF |
DB2CONN=TSO | Select TSO access |
STORAGE=1000K | Trace Display buffer space is in BBI-SS PAS extended private area |
ELAP=12.5 | Keep only those with elapsed time >=12.5 seconds |
LOGTRAC=Y | Logging |
TITLE=‘LONG QMF QUERIES’ | Trace title |
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*