You can view activity for SQL text of interest.
On the Db2 Query Monitor main menu, type 1 in the
Option field and press Enter.
Select the summary level that you want to view.
- Locate the SQL activity for which you want to view SQL
Type S in the CMD field next to the SQL activity
of interest and press Enter.
The Activity by SQL Text
panel is displayed:
When you view SQL text
for rows that display dynamic text, the Db2, Plan,
Program, and Section number columns are