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) |