| COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
| ARTIF_KEY |
✔ |
artif_key: Artificial Key for Uniqueness |
|
INT4 |
10 |
|
| CALLERFLAG |
✔ |
Who Has Called this Program |
|
CHAR |
1 |
|
| DBMSTRTTME |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| PRGVERS |
|
Version of Program Inserted this Row |
|
CHAR |
20 |
|
| NUM_EXECUT |
|
num_executions: Number of Executions |
|
DEC |
22 |
|
| NUM_COMPIL |
|
num_compilations: Number of Compilations |
|
DEC |
22 |
|
| PREPTWORST |
|
prep_time_worst: Worst Preparation Time (ms) |
|
DEC |
22 |
|
| PREPTBEST |
|
prep_time_best: Best Preparation Time (ms) |
|
DEC |
22 |
|
| INT_RW_DEL |
|
int_rows_deleted: Rows Deleted |
|
DEC |
22 |
|
| INT_RW_INS |
|
int_rows_inserted: Rows Inserted |
|
DEC |
22 |
|
| RW_READ |
|
rows_read: Rows Read |
|
DEC |
22 |
|
| INT_RW_UPD |
|
int_rows_updated: Rows Updated |
|
DEC |
22 |
|
| RW_WRITTEN |
|
rows_written: Rows Written |
|
DEC |
22 |
|
| STMT_SORTS |
|
stmt_sorts: Statement Sorts |
|
DEC |
22 |
|
| TOTEXETS |
|
total_exec_time_s: Total Execution Time (sec) |
|
DEC |
22 |
|
| TOTEXETMS |
|
total_exec_time_ms: Total Execution Time (ms) |
|
DEC |
22 |
|
| TOTUSRCTS |
|
tot_u_cpu_time_s: Total User CPU Time (sec) |
|
DEC |
22 |
|
| TOTUSRCTMS |
|
tot_u_cpu_time_ms: Total User CPU Time (ms) |
|
DEC |
22 |
|
| TOTSYSCTS |
|
tot_s_cpu_time_s: Total System CPU Time (sec) |
|
DEC |
22 |
|
| TOTSYSCTMS |
|
tot_s_cpu_time_ms: Total System CPU Time (ms) |
|
DEC |
22 |
|
| DB_NAME |
|
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| PL_D_LRS |
|
pool_data_l_reads |
|
DEC |
22 |
|
| PL_D_PRS |
|
pool_data_p_reads |
|
DEC |
22 |
|
| PL_I_LRS |
|
pool_index_l_reads |
|
DEC |
22 |
|
| PL_I_PRS |
|
pool_index_p_reads |
|
DEC |
22 |
|
| PL_TD_LRS |
|
pool_temp_data_l_reads |
|
DEC |
22 |
|
| PL_TD_PRS |
|
pool_temp_data_p_reads |
|
DEC |
22 |
|
| PL_TI_LRS |
|
pool_temp_index_l_reads |
|
DEC |
22 |
|
| PL_TI_PRS |
|
pool_temp_index_p_reads |
|
DEC |
22 |
|
| SORT_OVERFLOWS |
|
sort_overflows |
|
DEC |
22 |
|
| TOTAL_SORT_TIME |
|
total_sort_time |
|
DEC |
22 |
|
| PL_XDA_LRS |
|
pool_xda_l_reads |
|
DEC |
22 |
|
| PL_XDA_PRS |
|
pool_xda_p_reads |
|
DEC |
22 |
|
| PL_TEMP_XDA_LRS |
|
pool_temp_xda_l_reads |
|
DEC |
22 |
|
| PL_TEMP_XDA_PRS |
|
pool_temp_Xda_p_reads |
|
DEC |
22 |
|
| STATS_FABRICATE_TIME |
|
|
|
DEC |
22 |
|
| SYNC_RUNSTATS_TIME |
|
|
|
DEC |
22 |
|
| ROWS_RETURNED |
|
|
|
DEC |
22 |
|
| STMT_PKGCACHE_ID |
|
|
|
DEC |
22 |
|
| INSERT_TIMESTAMP |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| STMT_LEN |
|
stmt_txtln: Length Field of LCHR stmt_txt |
|
INT4 |
10 |
|
| STMT_TEXT |
|
stmt_text: SQL Statement |
|
STRI |
0 |
|