Viewing SQL text
When
you enter a B next to an entry on the Session Activity List panel and press Enter,
the SQL Text Browse panel is displayed (if SQL text is available).
This panel displays the actual SQL statement being executed.
Table 88. SQL Text Browser
DB2P -- SQL Text ------------------------------------------------------ 8.1.0
Command ===> Scroll ===> PAGE
Object :
Date Time TSOID SQLID Mode Rows CPU
---------- -------- -------- --------- ------ --------- -----------
-----------------------------------------------------------------------------
***************************** BOTTOM OF DATA ********************************
|
If you press Enter, no action is performed.
If you press PF3, you will return to the
Session Activity List panel.
The fields on the panel are:
- Date
- This field displays the date on which the command that activated database
activity began.
- Time
- This field displays the time on which the command that activated database
activity began.
- TSOID
- For online sessions, this field displays the TSOID of the
user who logged on to QMF. For batch sessions, it displays the user
ID associated with the batch job.
- SQLID
- This field displays the CURRENT SQLID at the time the command
was initiated.
- Mode
- This field displays the mode in which the command was run,
either ONLINE or BATCH.
- Rows
- This field displays the accumulated number of rows fetched
at the time that the SQL text was captured for the query.
- CPU
- This field displays the accumulated CPU time consumed at the
time that the SQL text was captured for the query.
