DB2 graphic QMF Version 8

Object activity summary table layout (Q.OBJ_ACTIVITY_SUMM)

Column Name Data Type Description
OBJOWNER CHAR(8) Object owner
OBJNAME VARCHAR(18) Object name
SSID CHAR(4) DB2 subsystem ID
FDATE DATE First-used date
FTIME TIME First-used time
FTSOID CHAR(8) First-used TSOID
FSQLID CHAR(8) First-used SQLID
FACTN CHAR(1) First-used action: X'01' ERASE; X'02' PRINT; X'03' DISPLAY; X'04' RUN; X'05' EXPORT; X'06' IMPORT; X'07' SAVE; X'09' CONVERT
FENVIRO CHAR(1) First-used environment: '2' or '3' TSO, '5' CICS, 'O' Object Manager, 'W' Windows
FMODE CHAR(1) First-used mode: '1' online session, '2' batch session
LDATE DATE Last-used date
LTIME TIME Last-used time
LTSOID CHAR(8) Last-used TSOID
LSQLID CHAR(8) Last-used SQLID
LACTN CHAR(1) Last-used action (see FACTN for values)
LENVIRO CHAR(1) Last-used environment (see FENVIRO for values)
LMODE CHAR(1) Last-used mode (see FMODE for values)
USE_CT INTEGER Number of times object has been used
CAN_CT INTEGER Number of times object has been canceled by the HPO/Governor module
RUN_CT INTEGER Number of times object has been run
Column Name Data Type Description
LMDATE DATE Last-modified date
LMTIME TIME Last-modified time
LMTSOID CHAR(8) Last-modified TSOID
LMSQLID CHAR(8) Last-modified SQLID
LMACTN CHAR(1) Last-modified action (see FACTN for values)
LMENVIRO CHAR(1) Last-modified environment (see FENVIRO for values)
LMMODE CHAR(1) Last-modified mode (see FMODE for values)
Note:
For data retrieval purposes, a unique index should be created on columns OBJOWNER and OBJNAME.


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