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