DB2 graphic QMF Version 8

Object activity detail table layout (Q.OBJ_ACTIVITY_DTL)

Column Name Data Type Description
OBJOWNER CHAR(8) Object owner
OBJNAME VARCHAR(18) Object name
SSID CHAR(4) DB2 subsystem ID
DATE DATE Date query was run
TIME TIME Time query was run
TSOID CHAR(8) TSOID running query
SQLID CHAR(8) CURRENT SQLID running query
ENVIRO CHAR(1) Environment in which query was run: '2' or '3' TSO, '5' CICS
MODE CHAR(1) Mode in which query was run: '1' online session, '2' batch session
ROWCT INTEGER Number of rows fetched
CPUCT INTEGER CPU time consumed (in hundredths of seconds)
SUCCESS CHAR(1) One of the HPO/Governor module cancel codes
SQLTEXT VARCHAR(3500) SQL Text
ETIME TIME Time query ended
IXTIME INTEGER HPO internal use
Column Name Data Type Description
BYTECT INTEGER Number of bytes fetched (not used by QMF HPO)
Note:
For data retrieval purposes, a unique index should be created on columns OBJOWNER, OBJNAME, DATE, TIME, and IXTIME.


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