DB2 graphic QMF Version 8

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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004