Viewing SQL text

When you enter a B next to an entry on the Session Activity List panel and press Enter, the SQL Text is displayed (if SQL text is available) in ISPF view. This screen displays the actual SQL statement being executed.

About this task

Figure 1. SQL text

VIEW       SYS10148.T101938.RA000.QMFUSER.R0200630          Columns 00001 00072 
 Command ===>                                                  Scroll ===> PAGE 
 ****** ***************************** Top of Data ******************************
 ====== OBJECT: QMFUSER.QUERY1                                                  
 ======                                                                         
 ====== DATE       TIME     TSOID    SQLID    MODE   ROWS      CPU              
 ====== ---------- -------- -------- -------- ------ --------- -----------      
 ====== 2010/05/26 14:38:03 QMFUSER  QMFUSER  ONLINE 35        00:00:00:00      
 ======                                                                         
 000001 SELECT * FROM Q.STAFF                                                   
 000002                                                                         
 ****** **************************** Bottom of Data ****************************

Note: The length of the SQL text displayed is determined during the configuration process. Refer to Step 3h. Setting the HPO/Governor module parameters for more information.

From the SQL Text Browse ISPF view:

If you enter the command ANALYZE on the command line and press Enter, Query Analyzer is invoked with the QMF query identified on this panel. This command is only valid for QMF queries. When you exit Query Analyzer, you return to this panel.
If you press PF3, you return to the previous panel.
If you press PF8 or PF7, the screen scrolls forward or backward.
If you press PF10 or PF11, the screen moves left or right

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.