DB2 graphic QMF Version 8

Viewing the session activity list

Within a session, you can see every QMF command that is being issued by the user. For actions that cause database activity, the number of rows fetched and the CPU time consumption are also displayed.

When you enter a B next to an entry on the QMF Session List panel and press Enter, the Session Activity List panel is displayed. This panel displays the detail activity being performed in the user's QMF session.

Table 86. Session Activity List
DB2P -- Session Activity List ----------------------------------------- 8.1.0
Command ===>                                                Scroll ===> PAGE
 
Valid Actions Are...
B  Browse SQL Text
C  Cancel Current Action
 
TSOID :
Mode  :                                                                    C S
                    QMF Object   Object                                    A Q
A Date     Time     Act Owner    Name                     Rows     CPU     N L
- -------- -------- --- -------- ------------------ ---------- ----------- - -
 
******************************* BOTTOM OF DATA ******************************
 
 
 
 
 
 
 
 
 
 
 

If you are displaying an active QMF session and you press Enter, the displayed data will be refreshed.

If you are displaying a QMF session that has ended and you press Enter, the displayed data will remain the same.

If you press PF3, you will return to the QMF Session List panel.

The fields on the panel are:

A
(Action): Enter B in this column to browse SQL text associated with a query, or C to cancel an active QMF command with database activity.
Date and Time
The date and time that the command started displays in these columns. If this entry indicates incremental database activity (that is, QMF Act is ***), the date and time will be the same as the corresponding entry for the command that initiated the database activity.
QMF Act
(QMF action): The QMF action that was performed displays in this column. Values that can appear here are:
Table 87. QMF Action Codes
Code Description
BEG Start QMF session
END End QMF session
ERA ERASE command
CNV CONVERT command
PRI PRINT command
DIS DISPLAY command
EXP EXPORT command
IMP IMPORT command
SAV SAVE command
RUN RUN command
*** Incremental database activity
Object Owner
The owner of the object against which the action is being performed displays in this column.
Object Name
The name of the object against which the action is being performed displays in this column.
Rows
The accumulated number of rows retrieved displays in this column. It is valid only for entries indicating incremental database activity.
CPU
The accumulated CPU time consumed displays in this column. It is valid only for entries indicating incremental database activity.
CAN
The cancel flag displays in this column. See "HPO/Governor module cancel codes" for more information on the values that can appear here.
SQL
If a Y appears in this column, then SQL text is available for viewing. Otherwise, no SQL text is available.


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