| COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
| AGENT_ID |
✔ |
agent_id: Application Handle |
|
DEC |
22 |
|
| 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 |
|
| STMT_NDNUM |
|
stmt_node_number: Node Where the Statement is Executing |
|
INT4 |
10 |
|
| STMT_TYPE |
|
stmt_type: Type of Statement: Dynamic or Static |
|
CHAR |
25 |
|
| STMT_OPERA |
|
stmt_operation: Current Operation |
|
CHAR |
50 |
|
| SECTIONNUM |
|
section_number: Section Number |
|
DEC |
22 |
|
| QY_COSTEST |
|
query_cost_estimate: SQL Compiler Estimated in TIMERONS |
|
DEC |
22 |
|
| QY_CARDEST |
|
query_card_estimate: SQL Compiler Estimated Number of Rows |
|
DEC |
22 |
|
| DG_PARA |
|
degree_parallelism: SMP Intraquery Parallelism Requested |
|
DEC |
22 |
|
| STMT_SORTS |
|
stmt_sorts: Number of Sorts for this Statement |
|
DEC |
22 |
|
| TOT_SRT_TM |
|
total_sort_time: Total Sort Time for this Statement |
|
DEC |
22 |
|
| SRT_OF |
|
sort_overflows: Number of Sort Overflows for this Stmt |
|
DEC |
22 |
|
| RW_READ |
|
rows_read: Number of DMS Rows Read |
|
DEC |
22 |
|
| RW_WRITTEN |
|
rows_written: Number of DMS Rows Read |
|
DEC |
22 |
|
| INT_RW_DEL |
|
int_rows_deleted: Number of Internal DELETEs by the Stmt |
|
DEC |
22 |
|
| INT_RW_UPD |
|
int_rows_updated: Number of internal UPDATEs by the Stmt |
|
DEC |
22 |
|
| INT_RW_INS |
|
int_rows_inserted: Number of internal INSERTs by the Stmt |
|
DEC |
22 |
|
| FETCH_CNT |
|
fetch_count: Fetch Count |
|
DEC |
22 |
|
| STMT_START |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| STMT_STOP |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
| CUR_NAME |
|
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| CREATOR |
|
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| PKG_NAME |
|
DB6: General identifier |
DB6IDENT |
CHAR |
20 |
|
| STMTURCTS |
|
stmt_usr_cpu_time.seconds: Total User CPU Time of SQL Stmt |
|
DEC |
22 |
|
| STMTURCTMS |
|
stmt_usr_cpu_time.microsec: Total User CPU Time of SQL Stmt |
|
DEC |
22 |
|
| STMTSYCTS |
|
stmt_sys_cpu_time.seconds: Total System CPU Time for SQL Stm |
|
DEC |
22 |
|
| STMTSYCTMS |
|
stmt_sys_cpu_time.microsec: Total System CPU Time for SQL St |
|
DEC |
22 |
|
| NUM_SS |
|
num_ss: Number of Subsections |
|
DEC |
22 |
|
| NUM_AGENTS |
|
num_agents: Number of Agents Currently Working on Stmt |
|
DEC |
22 |
|
| AGENTS_TOP |
|
agents_top: Number of Agents Created for Statement |
|
DEC |
22 |
|
| PL_D_LRS |
|
pool_data_l_reads: Pool Data Logical Reads Since Connect |
|
DEC |
22 |
|
| PL_D_PRS |
|
pool_data_p_reads: Pool Data Reads Since First Connect |
|
DEC |
22 |
|
| PL_I_LRS |
|
pool_index_l_reads: Pool Index Logical Reads Since Connect |
|
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 |
|
| BLKCURSOR |
|
blocking_cursor |
|
CHAR |
10 |
|
| STMTELAS |
|
elapsed_time seconds |
|
DEC |
22 |
|
| STMTELAMS |
|
elapsed_time microseconds |
|
DEC |
22 |
|
| CONSISTNCY_TOKEN |
|
consistency_token |
|
CHAR |
128 |
|
| PACKAGE_VERS_ID |
|
package_version_id |
|
CHAR |
128 |
|
| PL_TEMP_XDA_L_RD |
|
|
|
DEC |
22 |
|
| PL_TEMP_XDA_P_RD |
|
|
|
DEC |
22 |
|
| POOL_XDA_L_READS |
|
|
|
DEC |
22 |
|
| POOL_XDA_P_READS |
|
|
|
DEC |
22 |
|
| STMT_LEN |
|
stmt_length: Lth of Dyn SQL Text Blank Padded to 4Byte Bndry |
|
INT4 |
10 |
|
| STMT_TEXT |
|
stmt_text: SQL Statement |
|
STRI |
0 |
|
