Neoview Repository User Guide (R2.4 SP1)

ORDER BY EXEC_START_LCT_TS DESC
FOR READ UNCOMMITTED ACCESS;
ValueField
2009-08-19 04:56:20.264828“EXEC_START_LCT_TS”
2009-08-19 11:56:20.264828“EXEC_START_UTC_TS”
“MXID01003030787212117386140307130000000009614SUPER.SERVICES00_254_SQL_CUR_61”“QUERY_ID”
2009-08-19 04:56:27.544543“ENTRY_ID_LCT_TS”
2009-08-19 11:56:27.544543“ENTRY_ID_UTC_TS”
\NEO0102“SEGMENT_NAME”
NEO01“PLATFORM_NAME”
“joesmith ”
1
“USER_NAME”
“ROLE.DBA”“ROLE_NAME”
148“START_PRIORITY”
\NEO0102.$Z2YK“PROCESS_NAME”
“MXID01003030787212117386140307130000000009614SUPER.SERVICES00”“SESSION_ID”
“ORDCLOVISRBTS-P2”“CLIENT_NAME”
“ODBC Test (ANSI) ”"APPLICATION_NAME"
“neo0102_clo”“DATASOURCE”
“SQL_CUR_26680060 ”“STATEMENT_ID”
“SQL_SELECT_NON_UNIQUE”“STATEMENT_TYPE“
“HP_DEFAULT_SERVICE”“SERVICE_NAME”
2“SEGMENT_ID”
1“NODE_ID”
2009-08-19 04:57:00.801175“SUBMIT_LCT_TS”
2009-08-19 11:57:00.801175“SUBMIT_UTC_TS”
2009-08-19 04:56:17.668589“COMPILE_START_LCT_TS”
2009-08-19 11:56:17.668589“COMPILE_START_UTC_TS”
2009-08-19 04:56:20.264466“COMPILE_END_LCT_TS”
2009-08-19 11:56:20.264466“COMPILE_END_UTC_TS”
2595877“COMPILE_ELAPSED_TIME”
2.595877“COMPILE_ELAPSED_TIME_SEC”
679458816“COMPILE_AFFINITY_NUM”
12“COMPILE_DEGREE_OF_PARALLELISM”
0“COMPILE_TRANSACTION_NEEDED”
0“COMPILE_MANDATORY_CROSS_PRODUCT”
0“COMPILE_MISSING_STATS”
0“COMPILE_NUM_JOINS”
1“COMPILE_FULL_SCAN_ON_TABLE”
76 Examples and Guidelines for Creating Repository Queries